UNWANTED: Auto time format - How to avoid?

Maxxman · Newbie Joined: 30 Aug 2005 Posts: 2

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...

DiGro · Posted: Tue Aug 30, 2005 7:24 am Post subject:

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

Maxxman · Newbie Joined: 30 Aug 2005 Posts: 2

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...

DiGro · Posted: Wed Aug 31, 2005 7:15 am Post subject:

Yep,

there is a lot to discover Laughing