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!
Format four digit number to put decimal after first two digits
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?
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
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
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
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.Originally Posted by 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.
In that case I'd use VBA:
Code:[A1:A20]=[A1:A20/100]
Posting Permissions
Reply With Quote
Bookmarks