removing leading zeros in numeric fields

[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

[Jerry W. Lewis]

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

Jerry

dingy101 wrote:

> 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

[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

[dingy101]

Thanks for help, programming group answered question.

Gary

"dingy101" wrote:

> 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