| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
NEGATIVE DATES IN EXCEL
I have a spreadsheet with what excel refers to as a negative date, example:
20030112. What I want to do is format the date as 2003/01/12 or 01/12/2003, but I can't find anything that works. I've used the format date function, the DATEVALUE function; formatted the date as text, numbers to attempt to reformat as a date. Is there a faster way to do this instead of manually placing a "/" to separate year-month-date. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| negative dates or times are displayed as # # # # | Excel Worksheet Functions | |||
| negative dates or times are displayed as # # # # | New Users to Excel | |||
| Set negative numbers to zero. Do not calculate with negative valu | Excel Discussion (Misc queries) | |||
| Sumif using dates and positive negative values | Excel Discussion (Misc queries) | |||
| NEGATIVE IN BARCKETS AND UK DATES | Excel Discussion (Misc queries) | |||
Threaded Mode
