remove leading zero in numeric field
 

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

remove leading zero in numeric field
 

you can format the cells under custom

#.000



--


Gary


"dingy101" wrote in message
...
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

remove leading zero in numeric field
 

Thanks Gary, this worked for me.

Gary

"Gary Keramidas" wrote:

you can format the cells under custom

#.000



--


Gary


"dingy101" wrote in message
...
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