I am retrieving data from an offsite system. I have no control over the formatting of the data.
I get a DATE, but it is formatted as TEXT. I just simply tried to change the format from TEXT to DATE (mm/dd/yyyy) and I end up with a single quote in from of the date in the cell. I could edit this out, but I have far too many retrieved files.
Is there a way to make the conversion from TEXT to DATE?
Thanks,
Rich Ramik
Try this trick:
Very clever. I sew what is happening and understand as well.
Thanks very much,
Rich Ramik
Cool video. For those who are in a hurry, the short version is: Select column, menu Data->Text to Columns, in the Text to Columns window select column again, then under “Fields:” select the correct Column type.
Hallo
Meanwhile importing this datafiles there’s very propably a dialog similar to that shown by @johnSUN.
At this stage you should be able to choose also the same column-type
I know what you are suggesting. I’ll have look more closely the next time I have to retrieve data.
Thanks very much,
Rich Ramik