ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I add a zero in front of a number in general format? (https://www.excelbanter.com/excel-discussion-misc-queries/33568-how-do-i-add-zero-front-number-general-format.html)

dvs

How do I add a zero in front of a number in general format?
 
When I type a number in the "General" format with a zero in front of the
numbers and move to the next cell, the zero disappears. I want the zero to
be in front of the number.

How do I fix this?

Bob Phillips

Format the range with the required number of zeroes, such as 000.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"dvs" wrote in message
...
When I type a number in the "General" format with a zero in front of the
numbers and move to the next cell, the zero disappears. I want the zero

to
be in front of the number.

How do I fix this?





All times are GMT +1. The time now is 03:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com