Format four digit number to put decimal after first two digits

[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.