I *suppose* you could try this, where the entries are now dates:

You'll need two empty columns - one for the TEXT() formula below, and
another column that is FORMATTED as text.

If the date is in A1, and using your example where 6/1 was converted into
Jan-6-05

=text(A1,"d/m") will give you 6/1 as a formula result. Copy it, and Paste
Special Values into the column that is formatted as text.

Good luck
Duke

"Alfred" wrote:

in an Excel 2002 sheet we have cells with general format and we put in
numbers like this one: 6/1.
A lot of people have access to this file
Someone changed some of the cells into a date format: 06-Jan-05
Unfortunately our backup is also corrupt.
Is there a way to revert this back?