format number to 3 decmals
There is a minor problem with that custom format though... whole numbers
will have a decimal point after them.
Rick
"Chad" wrote in message
...
Try custom formatting the cell to the following:
0.###
Hope this helps,
Chad
"Montana" wrote:
I need a cell to format to 3 decimal points max, but I dont want the .000
if
the number is whole.
For example, I need a cell with 33.8140226 to read as 33.814, but if the
cell is 33, I want it to be 33, not 33.000
If I use general format, I can get the 33.814, but then I get 33.000 when
I
use a whole number.
Any help would be appreciated.
|