Use this formula to empty cell and copy and paste as value to original cell.
H17 is a cell which contains 1999-02-01

=DATE(,MID(H17,6,1),MID(H17,8,1))

"spreadsheet monkey" wrote:

I am having some problems with data from one system being exported to excel.
the data I get from the system is translated by excel into another format and

it is supposed to come out as 2/1 but instead in interpreted as feb-01. I
can't change the format in order to get the correct value, so I think I need
a function for it.
I can re-format the value to 1999-02-01 but them, I need a function to
remove the first 5 digits and replace the (-) with a (/).

can anybody help me?