Office 2007 + formatting cells

  • Thread starter Thread starter Neil Holden
  • Start date Start date
N

Neil Holden

I have a cell with 6 numbers in for example 098737.

Excel deletes the zeros off from the cell, when i right click format cells
and go to custom i change general to 000000 but it changes it to chinese?
Can anyone help please?
 
Neil,

The quickest way to keep the formatting is to put an apostrophe in front of
your number. Like this: '098737

When you hit enter, Excel formats the cell as text and keeps your leading
zero.

HTH.
 

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

Format Cell/Number 10
2007: Number format <> Number format 1
Numbers showing Up Centered in Cell ? 1
CELL FORMAT 5
Formatting not protected when paste 7
Remove date format? 3
Workbook cells won't hold formatting in Office 2007 2
Custom Number Format for text 8

Back
Top