T
toyota58
How do I enter text that starts with a zero and have the cell show the
zero.
Example :
0256
0891
0188
etc
Thank You.
zero.
Example :
0256
0891
0188
etc
Thank You.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob Umlas
Start with a leading single quote, which won't show.
Bob Umlas
Excel MVP
Bob Umlas
Excel MVP
D
Dodo
How do I enter text that starts with a zero and have the cell show the
zero.
Set the cell or column format before entering to text.
T
toyota58
Thank You. Problem solved.
L
Line N. Online
1. Format > Cells > Number
2. Category: Custom
3. Type: 0000
4. Click "OK"
2. Category: Custom
3. Type: 0000
4. Click "OK"
G
GeorgeB
1. Format > Cells > Number
2. Category: Custom
3. Type: 0000
4. Click "OK"
The single quote (and this?) work when the text is keyed; I frequently
paste from Mozilla/Firefox/IE, and that problem, as well as fractions
like 1/6 turning into dates are a pain, and seem to be uncorrectable;
is there a way to have pasting be taken literally. BTW, I have tried
the paste special options