removing leading zeros in numeric fields

[Guest]

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

 

[Jerry W. Lewis]

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

Jerry

 

[Guest]

Thanks for help, programming group answered question.

Gary

 

[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