Decimal Format
Posted by Matt on July 31, 2001 12:04 PM
I have a column of numbers where I need to show 4 decimal places.
49590 needs to become 4.9590
I know you have to use custom format, but I can't remember exactly how to do it. Any help would be appreciated. Thanks!
Posted by Mark W. on July 31, 2001 12:32 PM
It appears that your value is an integer. You'll
need to divide by 10,000 then apply the Number
format with 4 decimal places using the
Format | Cells... menu command
Posted by Matt on July 31, 2001 12:49 PM
Shortly after I posted this, it came back to me. Under Custom format, delete the word general out and type 0"."0000
Posted by Mark W. on July 31, 2001 1:05 PM
Be careful...
...your format doesn't change the internal
representation of your value. Thus, it will
appear that 4.9590 * 10 = 495,900 which
obviously it does not!
