Dairyfarmer
Executive Member
The question I asked. TY.
I'll keep looking for a solution that does not require having to select a formatting style everytime.
-
Join the MyBroadband community
South Africa’s biggest forum. Discuss, discover, and connect with thousands of members.
-
Question of the Day: What's the most interesting small town you've visited in South Africa?
Excel Change Default Date Format
- Thread starter Dairyfarmer
- Start date
I'll keep looking for a solution that does not require having to select a formatting style everytime.
RedViking
Nord of the South
Besides changing your regional systems settings and using style format you wont. It has been irritating the crap out of me for years and I don't even use excel that often. But if you do find a solution, you will be a hero.
RedViking
Nord of the South
Dairyfarmer
Executive Member
It thinks it's text! Because, in number format, 1/1/1900 = 1, 31/12/1900 = 366. Try converting 0 into long date = 00 January 1900.
If you want to calculate differences in dates that are before 1900 you can by using VB script.
Dairyfarmer
Executive Member
Nope. It is the way Excel handles dd/mm. It sees it as a date and displays it as dd-MMM. You can then change it if you select formatting it will use the date formats that are set in Windows or anything you want via custom.
What I am trying to do is get Excel to display dd/mm as dd/mm/yy without the need to do anything. Not format, not regional settings, not custom templates, not styles,.........
If Excel can display dd/mm as dd-MMM, why can't we change Excel to default to dd/mm/yy rather than dd-MMM?
TribbleZA
Honorary Master
Ah I get it now. It is possibly built into the code. But Microsoft is asking for suggestions for improvements, why not ask them to add this ?
@Dairyfarmer in the screen @KT-B posted above (post #25) try unchecking "cells containing years, represented as 2 digits"
TribbleZA
Honorary Master
Sadly that doesn't help as he is not typing the year. It is supposed to default to short date format according to MS - but it doesn't. Something is no longer working as it should.
Dairyfarmer
Executive Member
Yip, ahhhhhhhhhhhhh Excel is so close. They got the "it's looks like a date" part right. It just needs to go one step further. I was hoping there would be a registry hack or something that would force Excel to use dd/mm/yy (or whatever your date format preference is) rather than just dd-MMM. Done quite a bit of Googling and found the same question, but never an answer other than "Regional Settings" and "Formatting".
Oh well, I'll use the same process I used way back when we were using WP5.1 . Do everything then apply formatting.
Do you only want it for the current date or for entering any date?
for current day (i.e today), excel has a shortcut, Ctrl + ;
If you need to type in other dates, you could probably do this with an app called PhraseExpress
for current day (i.e today), excel has a shortcut, Ctrl + ;
If you need to type in other dates, you could probably do this with an app called PhraseExpress
RedViking
Nord of the South
Simply put. IT IS NOT POSSIBLE.
Microsoft want you to do it their way. Their way is the best. Always.
Microsoft want you to do it their way. Their way is the best. Always.
Most likely possible with a Text Expander app (as a workaround, due to it not being built into Excel)
RedViking
Nord of the South
Then you can just as well use style format.... but yeah. Not possible without some 3rd party app.
With a text expander app like phrase express it applies changes as you type (depends on config) so no user intervention is required.
You can also configue macro's within phrase express.
RedViking
Nord of the South
lol.. Glad you found it.. It's an amazing application. I use it daily on both my PC's & on my phone.