Excel Change Default Date Format

[RedViking]

lol.. Glad you found it.. It's an amazing application. I use it daily on both my PC's & on my phone.

Will this standard option be good enough? I can't see that I need all the other extra stuff?



Which version do you use?

 

[ponder]

I'll keep looking for a solution that does not require having to select a formatting style everytime.

Excel seems to be applying a default custom format to dd-mmm for text strings resembling a date in a general cell. If you look at the custom options yyyy/mm/dd is there but excel is programmed to default to dd-mmm which is also an option. I've googled but cannot find anything on how to change this default behaviour.

 

[RedViking]

Excel seems to be applying a default custom format to dd-mmm for text strings resembling a date in a general cell. If you look at the custom options yyyy/mm/dd is there but excel is programmed to default to dd-mmm which is also an option. I've googled but cannot find anything on how to change this default behaviour.

You can't.

 

[ponder]

You can't.

That's daft though.

 

[RedViking]

That's daft though.

No it is not. Microsoft said so.

 

[TribbleZA]

You should be able to change it according to Microsoft's doc - but it appears to be broken. I pasted it in an earlier post. The need to be notified that it is not working any more.

 

[mh348]

Will this standard option be good enough? I can't see that I need all the other extra stuff?

View attachment 749743

Which version do you use?

Standard version, I was on the Free version until recently & then bought the standard license as I use it alot.

 

[RedViking]

Standard version, I was on the Free version until recently & then bought the standard license as I use it alot.

I'll just go standard then.