ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   using numbers (https://www.excelbanter.com/excel-discussion-misc-queries/129691-using-numbers.html)

teddyruth

using numbers
 
when I type 01, it changes to 1 How do I get it to stay as typed?

daddylonglegs

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?


JLatham

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