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

UNWANTED: Auto time format - How to avoid?

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

Are you so stupid you don't know how to format a date or a time?
What's a format?
0%
 0%  [ 0 ]
Nope, just lazy...
0%
 0%  [ 0 ]
I love the auto formatting option!
100%
 100%  [ 2 ]
Wh ar al my wor unfinis ?
0%
 0%  [ 0 ]
Total Votes : 2

Author Message
Maxxman
Newbie
Newbie


Joined: 30 Aug 2005
Posts: 2

PostPosted: Tue Aug 30, 2005 6:55 am    Post subject: UNWANTED: Auto time format - How to avoid? Reply with quote

I'm making a list of names with name adres zip etc. This has been going fine until i came across Zipcode 2543 AM (Holland), which automatically is renamed to ### which in turn (when the cell is highlighted) turns into 2543:00:00. There is no way i can get this function to stop or work around it. People with a Zipcode ending on AM or PM, about 20.000 peops in Holland cant be added to a list in OO. Hmmmm.

In Holland we dont have the AM/PM addition to time so it took a while to find out it was a (auto) time format that does it.

I tried turning off every known autocompleter etc but this still happens.

2 questions:

How do I get rid of this?

Why do softwaredesigners assume their users don't know how to format the time themselves?

Hope to find an answer here, thx in advance.
_________________
I'll decide what ime it is, or if its time at all...
Back to top
View user's profile Send private message
DiGro
Super User
Super User


Joined: 02 Jun 2004
Posts: 1415
Location: Hoorn NH, The Netherlands

PostPosted: Tue Aug 30, 2005 7:24 am    Post subject: Reply with quote

maxxman,

Select the column where you have you're unwanted timeformat
(click on the letter on the top (in case you didn't know this Laughing ))

Choose Format > Celformat > on the tab Numbers select under Category the option Text
(Dutch: Opmaak > Cel Opmaken > op de tab Getal selecteer onder Categorie Tekst)

Now you will have your Dutch zipcode back Laughing

Second part of you're question:
It is a matter of choices. Some people love it, some people don't. It's life.
The advantage is that you can turn it off and make it whatever you want.

DiGro
Back to top
View user's profile Send private message
Maxxman
Newbie
Newbie


Joined: 30 Aug 2005
Posts: 2

PostPosted: Tue Aug 30, 2005 11:59 pm    Post subject: Thanks a lot Reply with quote

I never thought to look there. There must have been a way. Dankjewel!!
It is logical to turn this of and on per collumn.

Groeten

Maxxman
_________________
I'll decide what ime it is, or if its time at all...
Back to top
View user's profile Send private message
DiGro
Super User
Super User


Joined: 02 Jun 2004
Posts: 1415
Location: Hoorn NH, The Netherlands

PostPosted: Wed Aug 31, 2005 7:15 am    Post subject: Reply with quote

Yep,

there is a lot to discover Laughing
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