Date not formatting correctly

Originally Posted by jambog

If I am understanding that correctly, I would have to create that formula for each 5 digit value, correct? So one formula for 42800, a separate formula for 42801, and so on. I may as well use find and replace, but either method is more time consuming that I would like. Thanks for the suggestions though.

Yes, but, if the values are in a nice list like your sample shows, that should be as simple as entering the TEXT() formula once and copying the formula down as far as needed. Or perhaps there is a better way of entering the data into the spreadsheet, and resolve the problem at the data entry step.

Your examples only show what the list might look like in Excel, with no discussion or example of how the date string is read by the mapping software and entered into the text string. Perhaps if we better understood what the mapping software was doing with the Excel data, something could be suggested.

I think that, if we had a better understanding of the overall process (data entry into Excel -- data processing in Excel -- mapping software reading data in Excel -- mapping software processes excel data (concatenate into text string)), we might be able to make better suggestions.