Forum Discussion
Date Formatting Won't Change
- Finally figured this out.
Change the date format of your computer from the taskbar.
Regardless of timezone and all, go to your task bar> click the time/date > region >then look for additional date, time & regional settings > change date, time and number formats> additional settings> then go to the date tab and you can manually set the format by using the MMM dd yyyy or whichever format you want it in. Restart your computer and it should work on excel.
Wew
I use large datasets and I find it way easier to import the data in Access, change the format there, then copy it back into Excel. It takes way less time than trying to figure out what's wrong with Excel formats
That's at least discussable what easier to use - Text to Columns, Power Query, Access, VBA programming or something else. Depends on what do you know better. If Excel, when Text to Columns or like. If another tool, when it.
- Hi! Can you please help me. Seems like imported data in excel is in different format, and dates I see excel reads as a text. I am working on more that 7000 rows of dates therefore cannot manually change date from 2018.09.28 to 09/28/2018 in order to work with it. Can you please help me? I tried text to column it didn't work for me
An additional column in the import table could also be useful. Replacing the period "." by hyphen "-" or forward slash "/" using
= --SUBSTITUTE([@DateText],".","/")
would give a date value column.
If that's one time operation you may select column with texts, on ribbon Data->Text to Columns and on third step of the wizard select source date formar
Now you shall have dates in your locale format
(I use ISO format) or apply any one which is more suitable for you.
If you import data on regular basis it's better to make such transformation within importing process, e.g. Power Query works fine with that.
- Thanks a lot
- I have tried date to text and everything else mentioned here. But nothing changes the date. Everything with a formula changes as normal. But everything else won't change no matter what formatting is used. The file was exported as CVS and then saved as an excel file. Please help, this is doing my head!
