G Guest Nov 21, 2005 #1 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
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 Nov 21, 2005 #2 Format|Cells|Number scroll down in the category list to Custom and in the Type field type .000 Jerry
B Bryan Hessey Nov 21, 2005 #4 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 Click to expand...
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 Click to expand...