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.
Type: Posts; User: 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.
That custom formatting worked! Thanks!!
That did work. I was just wondering if I could come up with a custom number format.
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!