OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Problem, i like a number not a date

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
Nero
Guest





PostPosted: Fri May 16, 2003 5:49 am    Post subject: Problem, i like a number not a date Reply with quote

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
Back to top
dfrench
Moderator
Moderator


Joined: 03 Mar 2003
Posts: 1605
Location: Wellington, New Zealand

PostPosted: Fri May 16, 2003 8:40 pm    Post subject: Reply with quote

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?
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group