![]() |
using numbers
when I type 01, it changes to 1 How do I get it to stay as typed?
|
using numbers
Pre-format the cell as text or type in '01.
Alternatively if you always want to show two digits, custom format cell as 00 "teddyruth" wrote: when I type 01, it changes to 1 How do I get it to stay as typed? |
using numbers
There are a couple of ways,
#1 - use Format | Cells | Custom and type in 00 that's zero-zero. Now all numbers entered will have 2 digits, and if you type in a single digit, the leading zero will even be added for you. Use as many zeros as you plan on having digits. #2 - format the cells as text. #3 - like #2, ends up with numbers as text in the cell: prefix each entry with an apostrophe (') Others should come along with other methods also. But those are 3 quick ways. "teddyruth" wrote: when I type 01, it changes to 1 How do I get it to stay as typed? |
All times are GMT +1. The time now is 02:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com