Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with dates
Hi There,
On my laptop when I enter a date in a cell (I am in UK so I have format day / month / year) as 1/12 it automatically changes it to 1/12/2005. But when I do the same on my desktop it changes it to 1/12/2006 - is there a setting that effects this as I can't see why it reacts differently. Ta Andi |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with dates
Hi
Check your Window's system date (Control PanelDate and Time, or in Excel, into any cell type =TODAy() - and check the returned date) -- Arvi Laanemets ( My real mail address: arvil<attarkon.ee ) "Andibevan" wrote in message ... Hi There, On my laptop when I enter a date in a cell (I am in UK so I have format day / month / year) as 1/12 it automatically changes it to 1/12/2005. But when I do the same on my desktop it changes it to 1/12/2006 - is there a setting that effects this as I can't see why it reacts differently. Ta Andi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
filtering dates | Excel Worksheet Functions | |||
Using dates for x-axis values as string instead of creating a scale | Charts and Charting in Excel | |||
How do I get Excell to sort dates that range from 1800 to 1900's | New Users to Excel | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
Problem with date base units for x axis | Charts and Charting in Excel |