Problem, i like a number not a date

Nero · Guest

Hi.

When i type 1.2 in a row in de calc, automaticaly is converted en 01/02/2003, but i like a number not a date ...

what is the problem ??

Thanks

dfrench · Posted: Fri May 16, 2003 8:40 pm Post subject:

I think that this may a locale issue. Some countries use a date format with . separators (1.2.2003) others with / separators (1/2/2003)

so if I type 1.02 into a default formatted cell that is exactly what I get but if I enter 1/02, I will get date 1/02/2003.

You may have to explore your 'options' and experiment with local and date formats to sort this out. Do you enter decimal numbers as 1,02?