ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I start an Excel entry with then number 0? (https://www.excelbanter.com/excel-discussion-misc-queries/22879-how-do-i-start-excel-entry-then-number-0-a.html)

cajundoc

How do I start an Excel entry with then number 0?
 
How do I start an Excel cell entry with the number 0? (i.e. a pin number or
zip code). Every time I enter it, then move out of the cell, the computer
automatically removes the 0 in front of the remaining numbers.

Marvin P. Winterbottom

format the cells text to begin with, or put a single quote ' in front of the
zero

N Harkawat

before entering data go to Format-Cells-Text
This will now allow you to enter the data with 0 prefixed to a number
OR
Enter ' before your number

"cajundoc" wrote in message
...
How do I start an Excel cell entry with the number 0? (i.e. a pin number
or
zip code). Every time I enter it, then move out of the cell, the computer
automatically removes the 0 in front of the remaining numbers.





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

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