Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
when I type 01, it changes to 1 How do I get it to stay as typed?
|
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
Completely baffled on what should be simple | Excel Discussion (Misc queries) | |||
conditional formatting | Excel Worksheet Functions | |||
How to generate sets of random numbers without having duplicates | Excel Worksheet Functions | |||
Why are 1/2 my numbers imported as text and the rest as numbers? | Excel Discussion (Misc queries) |