format number to 3 decmals
 

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.

format number to 3 decmals
 

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.

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.

format number to 3 decmals
 

Thanks, that did it.

"Chad" wrote:

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.