Format four digit number to put decimal after first two digits

[keithconnolly]

That custom formatting worked! Thanks!!

[Rick Rothstein]

That custom formatting worked! Thanks!!

You need to keep in mind, though, that the value for that cell is NOT what you see in the cell... your value does not physically change, only its display. So if you type 1234 in the cell, you see 12.34 BUT if you calculate with that value, your calculation will use the full value 1234.

[keithconnolly]

Thanks Rick. One of our databases does not use a decimal to report cents, so I was trying to find a way to clean up the presentation a little.