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

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

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

Format the cell as #.000


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
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=486741