excel doest not shows the number starting with 0..is there is any way to solve this.

  • Thread starter Thread starter naughtyboy
  • Start date Start date
N

naughtyboy

i want to write codes in a cloumn A1..
all the codes begins with 0 and when i write any code which starts wit
0..then code is not displayed with 0...suppose i want to write th
code......

0441
03241

but excel does not shows the zero .is theer any way to solve thi
problem.
 
Enter the code as '0441 and '03241. It will then show as 0441 and 03241
 
If you format the cells as text, they will appear EXACTLY as you type
them..
 
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

how to show numbers that begin with 0 in excel 2
zip codes starting with 0 1
how to start with 0 in a cell in excel 1
How do I format cells to show the number 0 as first number in seri 2
Postcodes starting with 0 4
zeros show as dashes in spreadsheet, want to show 0. 2
Excel 2007 Formula and VBA help 5
Replace #DIV/0 error with zeros 6

Back
Top