removing leading zeros in numeric fields

D

dingy101

How do I remove leading Zeros in numeric fields that are less than 1.000?

example, 0.123, I would like to have .123.

Thanks

Gary
 
J

Jerry W. Lewis

Format|Cells|Number scroll down in the category list to Custom and in
the Type field type .000

Jerry
 
B

Bryan Hessey

Format the cell as #.000

How do I remove leading Zeros in numeric fields that are less than
1.000?

example, 0.123, I would like to have .123.

Thanks

Gary
 
Top