Is there a way to format a four digit number to put a decimal after the first two digits?
For example, 3568 would become 35.68.
All numbers are currently in the General format.
Thanks!
Is there a way to format a four digit number to put a decimal after the first two digits?
For example, 3568 would become 35.68.
All numbers are currently in the General format.
Thanks!
Why don't you just divide it by 100 in the adjacent cell?
That did work. I was just wondering if I could come up with a custom number format.
try percentage
Try custom number format 00\.00
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.
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.
In that case I'd use VBA:
Code:[A1:A20]=[A1:A20/100]