Carolyn J

[cj92119]

I have a spreadsheet containing a column of sequenced project numbers. The format is YY-xxxx (xxxx is a sequenced number). 80% of the column is formatted correctly showing 09-1234, 09-1235, 10-0001, etc. But the other 20% show as dates. Instead of 09-1234, it thinks it is September 1, 1234. I can use Month, Year and Concatenate functions to convert this back to the YY-xxxx format but I think there must be a better way.

Any ideas on how to convert an erroneous date back to a formatted text field. I need to change the data, not just the format, so that I can sort the field with the other sequenced numbers.

Help!!

[Roger Govier]

Hi Carolyn

Welcome to the forum.

Can you upload a sample file, as I cannot re-create you problem.

Click on go Advanced and then use the paperclip icon to upload your file..

[Paul]

Hi Carolyn, welcome to the forum.

Please take a moment to review the forum rules - link in my signature below - and then amend your thread title to something descriptive of your problem.

Thank you.