Date Format

[ExcelRoy]

Hi all,

I have an issue with date format, desptite changing the format for 23/01/2023 it stays at 1/23/23

also formulas fail to work with this format in this state
could this be a language issue, seems ok and set to English UK

Any help would be appreciated

Thanks

 

[awoohaw]

Could the data in the cell be a text value that looks like "1/23/23"?

 

[ExcelRoy]

Hi awoohaw

I have checked and it seems formatted to date

Thanks

 

[ExcelRoy]

If i type 1/23/23 it works fine?

 

[awoohaw]

Maybe, try typing a different date and then the date you want.

 

[ExcelRoy]

Hi awoohaw,

Tried that also, unfortunately same result

Thanks

 

[awoohaw]

What happens if you format a different cell the way you want, then type in your date? If that works then drag that cell overtop of the bad cell.

 

[ExcelRoy]

Hi,

Yes tried that also, must be something in the set up somewhere, even tried to start again with the workbook and still the same

Thanks

 

[Fluff]

I have checked and it seems formatted to date

If you format the cell as general do you still see a date?

 

[ExcelRoy]

Hi Fluff,

It shows 1/23/23 in the formula bar but displays 23/1/23
Its a bit strange

Thanks