Date

  • Thread starter Thread starter Lena Hermansson
  • Start date Start date
L

Lena Hermansson

Hi.

In Sweden the short way to write a date is on the format dd/MM.
I have set up the cell format as Date -> 14-mars.
When I type in the date 26/12 it is converted to 26-dec (as it should) but
when I type 04/12 it is converted to 12-apr instead of 4-dec as I want.

How do I get exel to convert the date according to Swedish settings?

Thanx in advanced.

/Lena
 
You should always enter dates in Excel using the year as well, otherwise it
will guess.

If the dates are only for display preformat the cells as text and it will
return whatever
you write otherwise use the year as well


--


Regards,


Peo Sjoblom
 
On Sat, 6 Dec 2008 12:39:02 -0800, Lena Hermansson <Lena
Hi.

In Sweden the short way to write a date is on the format dd/MM.
I have set up the cell format as Date -> 14-mars.
When I type in the date 26/12 it is converted to 26-dec (as it should) but
when I type 04/12 it is converted to 12-apr instead of 4-dec as I want.

How do I get exel to convert the date according to Swedish settings?

Thanx in advanced.

/Lena
Click to expand...

If you are using Windows:

Start/Control Panel/Regional and Language Options

and ensure your short date settings are appropriate.

The default for Sweden is yyyy-MM-dd, so you will need to customize this.
Select Customize next to the Swedish entry; then select the date tab;
under short date insert something like dd/MM

--ron
 
Back
Top