| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
convert date 1900
I tried to force a date column to a text column by
inserting a tick before the date. This works fine but if the date 01.01.1900 the result is '31.12.1899 . the macro line is : Dim cell As Range ... cell = "'" & cell what is wrong ? thx for your help rainer |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert Excel sheet in 1904 format to 1900 without changing dates | Excel Worksheet Functions | |||
| Replace date 00.01.1900 | Excel Discussion (Misc queries) | |||
| Date Conversion pre. 1900 | New Users to Excel | |||
| HAVE A COLUMN OF DATE PAYMENTS ARE DUE DATE CHANGES TO 01/00/1900 | Excel Discussion (Misc queries) | |||
| Date format pre-1900. | Excel Discussion (Misc queries) | |||
Threaded Mode
