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

 

[Fluff]

If you change the cell format to General & still see 23/1/23 in the cell, then it is text & not a date.

 

[ExcelRoy]

Hi Fluff,

Ah ok, but it says its a date format?

Thanks by the way

 

[Fluff]

Changing the format does not change the value of the cell, just how it's displayed.
Dates are just numbers with a special format.

 

[Joe4]

Hi Fluff,

Ah ok, but it says its a date format?

Thanks by the way

You can apply a Date format to a text entry, it just won't do anything!
Formatting only works on numeric entries (and dates are really just numbers with special formats, as Fluff said).

So you need to re-enter or convert your entries to valid number/date entries first.
(Either manually or with a Text-to-Columns approach).

 

[ExcelRoy]

Hi Joe4,

Still no luck
Even if i open a blank workbook and enter 23/1/23 its the same

 

[Joe4]

Try entering your date in cell A1.
Then enter this formula in cell B1 and tell us what it returns:

=ISNUMBER(A1)