Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
leading zeros
I am creating a column of passwords some of which need to begin with a zero.
When I move to a new cell it automatically drops the initial zero and is making my 4 digit password 3 numbers. Is tehre a way to keep it set as a number not text and still elt it hold the inital 0? I am using Excel 2002. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
leading zeros
thanks. that worked.
"Sloth" wrote: use a custom number format of 0000 "P. Zicari" wrote: I am creating a column of passwords some of which need to begin with a zero. When I move to a new cell it automatically drops the initial zero and is making my 4 digit password 3 numbers. Is tehre a way to keep it set as a number not text and still elt it hold the inital 0? I am using Excel 2002. Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
leading zeros
Don't use zeroes as the first character in your password? Okay, just
kidding. Enter a ' before the number or first select the column and format as text. If they're all 4-digit, you could Format--Cells--Number tab, choose custom and put 0000 in the box. ************ Anne Troy VBA Project Manager www.OfficeArticles.com "P. Zicari" wrote in message ... I am creating a column of passwords some of which need to begin with a zero. When I move to a new cell it automatically drops the initial zero and is making my 4 digit password 3 numbers. Is tehre a way to keep it set as a number not text and still elt it hold the inital 0? I am using Excel 2002. Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
leading zeros
use a custom number format of 0000
"P. Zicari" wrote: I am creating a column of passwords some of which need to begin with a zero. When I move to a new cell it automatically drops the initial zero and is making my 4 digit password 3 numbers. Is tehre a way to keep it set as a number not text and still elt it hold the inital 0? I am using Excel 2002. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Spliting a number with leading zeros | Excel Discussion (Misc queries) | |||
Format a cell to keep leading zeros. | New Users to Excel | |||
How do I force leading zeros in an Excel cell? | Excel Discussion (Misc queries) | |||
Leading zeros | Excel Discussion (Misc queries) | |||
save text field w/ leading zeros in .csv format & not lose zeros? | Excel Discussion (Misc queries) |