format number to 3 decmals

[Guest]

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.

 

[Guest]

Try custom formatting the cell to the following:
0.###
Hope this helps,
Chad

 

[Rick Rothstein \(MVP - VB\)]

There is a minor problem with that custom format though... whole numbers
will have a decimal point after them.

Rick

 

[Guest]

Thanks, that did it.

Try custom formatting the cell to the following:
0.###
Hope this helps,
Chad