ExcelBanter - Leading Zero's

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Leading Zero's (https://www.excelbanter.com/excel-discussion-misc-queries/208075-leading-zeros.html)

LascaJ

Leading Zero's

How do I get rid of leading zero's? I am trying to enter the caliber of a
gun. For instance .308 and it gives me 0.308. I am using the "general"
numbers setting and have tried the others, can't seem to get it right.

Gary''s Student

Leading Zero's

Format Cells... Number Custom .000
--
Gary''s Student - gsnu200810

"LascaJ" wrote:

How do I get rid of leading zero's? I am trying to enter the caliber of a
gun. For instance .308 and it gives me 0.308. I am using the "general"
numbers setting and have tried the others, can't seem to get it right.

All times are GMT +1. The time now is 05:11 PM.