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?