Formating cells with date format

[Guest]

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

 

[Olly]

http://www.cpearson.com/excel/datetime.htm

 

[Niek Otten]

Excel's date system starts with 1-1-1900.

If you need older dates (not just as text), you could download John
Walkenbach's extended date functions. You'll need the special functions that
go with it to calculate with those dates.

http://www.j-walk.com/ss/excel/files/xdate.htm

 

[Guest]

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: