ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   What is this Date problem? (https://www.excelbanter.com/excel-discussion-misc-queries/95846-what-date-problem.html)

Ozzy

What is this Date problem?
 
I'm typing a date into excel like I did loads of times in a UK date set
column. Suddenly Excel isn t formatting dates or else it stays changing them
to US.I tried setting Windows' Language Settings and reformatting the
column's cells but both didnt work.
Does anyone have a solution for this?

Ozzy

What is this Date problem?
 
Please Can Anyone Help me I need Help URGENTLY

"Ozzy" wrote:

I'm typing a date into excel like I did loads of times in a UK date set
column. Suddenly Excel isn t formatting dates or else it stays changing them
to US.I tried setting Windows' Language Settings and reformatting the
column's cells but both didnt work.
Does anyone have a solution for this?


Ron Rosenfeld

What is this Date problem?
 
On Sat, 24 Jun 2006 04:35:01 -0700, Ozzy
wrote:

I'm typing a date into excel like I did loads of times in a UK date set
column. Suddenly Excel isn t formatting dates or else it stays changing them
to US.I tried setting Windows' Language Settings and reformatting the
column's cells but both didnt work.
Does anyone have a solution for this?


Double check that in Windows/REgional settings that the format of the short
date matches the UK date order.


--ron


All times are GMT +1. The time now is 03:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com