Reversing the decimal separator auto date recognition function?

[Jaymond Flurrie]

Does someone here have a VBA script that reverses the date transforms? That is, when Excel sees stuff like 11.84, it says that "yippee, this is a date and I couldn't care less whether you think otherwise -> Nov.84 that is and you as a user can shove your ideas of numbers to where the sun doesn't shine". And no, changing that to number format definitely does not give anything close to correct results, since the number is counted from 1900 or 1904 dates and gives tens of thousands as the result.

So, I'm looking for a script that simply will undo the the date recognize. And no, this can't be any manual work of cell formattings etc. since I have accounting data of thousands of rows that comes from a source file, that might already be "infected".

Basically the function could be something like

Function reverseidiotictranslation(infecteddata As String)        
    Dim result As Double
    result = whateverthetranslationfunctionactuallyis(infecteddata)
    reverseidiotictranslation = result
End Function

but I think this has been already solved somewhere carefully, so most likely no need to re-invent the wheel.

 

[Jaymond Flurrie]

I can't swear 100% but use a copy, try it and see if you get usable data, the worst that could happen is you damage a bad copy

Otherwise good, but I have no idea what the original data is supposed to be. I would guess it is two way conversion, so if 1.10 becomes Jan 2010, then Jan 2010 becomes 1.10., but I'm not sure of that either.