Formating cells with date format

A

Alexandre Duarte

Hi everyone.
I have a worksheet with two columns. The first with date and the other with
text formated cells.
When I enter in the first one data with the year < 1900 the format never
assumes the right date format
Can anyone provide me with some explanation about this?
Regs
Alexandre Duarte
 
A

Alexandre Duarte

Thanks Niek, I downloaded the extended date functions and it work properly.
But, and sorry for insist, is there a way to apply the function to a range
of cells already with data?
In fact the user has already enter a several lines with data and now she has
to erase it and reenter all data building the xdate function?!
It's also not possible to build one function and paste special only that
function to others cells.
Sorry for the english ...
Regards
Alexandre Duarte

"Niek Otten" escreveu:
 
Top