ExcelBanter - numbers with 0 prefix

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

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

- - numbers with 0 prefix (https://www.excelbanter.com/excel-discussion-misc-queries/79258-numbers-0-prefix.html)

blu

numbers with 0 prefix

i want to be able to key in numbers with zero in front without excel dropping
zeros.

Peo Sjoblom

numbers with 0 prefix

Format as text, or precede entry with an apostrophe or use a custom format
0000 (for 4 digits always showing), the last assumes you always have the
same number of digits

--

Regards,

Peo Sjoblom

"blu" wrote in message
...
i want to be able to key in numbers with zero in front without excel
dropping
zeros.

All times are GMT +1. The time now is 04:52 PM.