ExcelBanter - In Excel how can i enter in a value like 0021 without the zeros .

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

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

- - In Excel how can i enter in a value like 0021 without the zeros . (https://www.excelbanter.com/excel-discussion-misc-queries/11215-excel-how-can-i-enter-value-like-0021-without-zeros.html)

Howie

In Excel how can i enter in a value like 0021 without the zeros .

In Excel how can i enter in a value like 0021 without the zeros disappearing
and leaving me with just 21?

Chip Pearson

Use a custom number format of 0000.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Howie" wrote in message
...
In Excel how can i enter in a value like 0021 without the
zeros disappearing
and leaving me with just 21?

All times are GMT +1. The time now is 01:43 AM.