| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dates converting to MS serial number
Scenario:
A1 value is "3/31/08" In column C15, I type the formula, '="For the month ending "&A1'. Problem: It used to return, 'For the month ending 3/31/08'. Now it returns 'For the month ending 39538'. I've tried changing the formatting and does not work. I tried other formulas for the date but still returns the MS serial number. Any help will be appreciated. Marco |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting Text Dates to Serial Numbers | Excel Worksheet Functions | |||
| Dates as Serial Values | Excel Discussion (Misc queries) | |||
| Serial Dates | Excel Discussion (Misc queries) | |||
| Averaging a Value Between Two Serial Dates | Excel Worksheet Functions | |||
| Converting dates to a number | New Users to Excel | |||
Threaded Mode
