ExcelBanter - Excel 2003 and 2007 problem

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel 2003 and 2007 problem (https://www.excelbanter.com/excel-discussion-misc-queries/252315-excel-2003-2007-problem.html)

Neil Holden

Excel 2003 and 2007 problem

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.

מיכאל (מיקי) אבידן

Excel 2003 and 2007 problem

Try: 000#
Micky

"Neil Holden" wrote:

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.

All times are GMT +1. The time now is 12:25 PM.