Text fields changed to date fields

G

guinness4breakfast

I have a file with text fields that have been converted to date fields. These
are numbers, some of which now have hyphens in them. Is there anyway to
restore this back to the original text fields.
 
G

guinness4breakfast

This is a currently existing file that has been corrupted. Now that numbers
have been turned into dates if I try and change the format back to text I
will get the date code instead of the norma text. An example being the number
5-18-74 has now been turned into a date, when formated to text I get 27167
when I would like to turn it back to 5-18-74. I am guessing this is
impossible at this point, but thought the board would be worth a shot.

Thanks,

Dave
 
Top