Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Date
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Date
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 "Lena Hermansson" <Lena wrote in message ... 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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Date
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Making a date go red, if date passes todays date. | Excel Worksheet Functions | |||
how to get the random date between the start date and the end date? | Excel Worksheet Functions | |||
Create a formula in a date range to locate a specific date - ecel | Excel Discussion (Misc queries) | |||
Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel |