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 |
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 |
All times are GMT +1. The time now is 08:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com