This is so simple a caveman could do it, but I can't.
I have imported a file which has our inventory locations listed.
When I open the file it have converted the text to a date and I can't convert it back to the text format.
Example: In cell A1 I have 10-22 and it converts to 22-Oct. When I try to convert to text it converts to a Julian date. I tried mid and left but it only gives me julian numbers.
Can someone help a caveman out?
Thanks
Re: Convert Date To Text
How exactly have you imported the data into Excel?
Re: Convert Date To Text
As norie implies, the best solution is probably to import the data differently (as text perhaps) but if you've already gone beyond that stage perhaps a formula like this will convert back
=MONTH(A1)&"-"&IF(YEAR(A1)=YEAR(TODAY()),DAY(A1),RIGHT(YEAR(A1),2))
Re: Convert Date To Text
I stand and applaud your last answer. This put a big smile on the "Caveman's" face.
Thanks
Re: Convert Date To Text
Rather than post a sample of imported data, how about posting a file (or a part of one) that you want to import, then I or someone can show a way of importing it without excel doing it conversions to dates?
p45cal
Re: Convert Date To Text
I can think of no reason to convert dates to text? If you must you simply use the Text Import Wizard and choose the format for that field as the last step.
Re: Convert Date To Text
Hi
Presumably your output file which you are opening in Excel is a csv file? That's the only file type that would result in an implicit and unavoidable conversion. If that's the case and if the import file has a standardised format, then I can help you out with some code to avoid this.
Richard
Don’t have an account yet? Register yourself now and be a part of our community!
