Excel 2003 and 2007 problem

N

Neil Holden

Hi all, i have a strange problem.

If i type 0001 into a cell it returns 1? If i then highlight the cells and
format cells and click custom and type 0000 it turns it into a special and
sets it the Portuguese as a language?

Can you help or inform me how i can do this please?

Neil.
 

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

concatenate & custom formats 1
Excel 2002; cell format confuses Custom and Special 2
Excel Typed text appears in wrong cell 0
Merging info from 5 cells to 1 7
Re: Cut and "insert cut cells" in Excel 2007 doesn't work. 9
Formating Date problem 2
Formatting Dates in excel 2
Excel 2007 extremely slow to delete cells 1

Top