I am creating an EXCEL worksheet with data in the form of 01-01-01. I need the cell to contain exactly that. I have formatted the cell using the text format. However when I place this data into the formatted cell it puts the value 36892 into the cell. If I look at the formatting on the cell it is text and If I now copy the value 01-01-01 into the cell it keeps it as 01-01-01.
I have thought of creating a custom format however the value can have dots instead of dashes between the numbers and there can be as many as ten sets of numbers.