Entering text that start with Zero ?

  • Thread starter Thread starter toyota58
  • Start date Start date
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.
 
Start with a leading single quote, which won't show.
Bob Umlas
Excel MVP
 
1. Format > Cells > Number
2. Category: Custom
3. Type: 0000
4. Click "OK"
 
1. Format > Cells > Number
2. Category: Custom
3. Type: 0000
4. Click "OK"
Click to expand...

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a cell with only PART of another cells data 4
How to display zeros at the beginning of a number? 5
zero values 5
The word "zero" appeared in a cell. 2
Stripping leading zeros 2
Number starting with zero 5
Displaying zeros in cells 2
Excel converts text cell contents to numbers (strips leading zeros)???!!! 1

Back
Top