| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formating cells with date format
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formating cells with date format
http://www.cpearson.com/excel/datetime.htm
"Alexandre Duarte" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formating cells with date format
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 -- Kind regards, Niek Otten "Alexandre Duarte" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formating cells with date format
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: 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 -- Kind regards, Niek Otten "Alexandre Duarte" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing date format in a footer | Excel Discussion (Misc queries) | |||
| Date Format Problems?? | Excel Discussion (Misc queries) | |||
| Imported Date & Time format with calcs. managed in excel from imrp | Excel Worksheet Functions | |||
| Min/Max formulas using cells with date format | Excel Worksheet Functions | |||
| Date Formatted Cells | Excel Worksheet Functions | |||
Hybrid Mode
