| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
negative dates
I'm using a simple formula to calculate the days from a start date
"=c21-today()" I cannot reverse the formula to get a negative number. Any tips on how to get this number to show up as "-nnn" thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
negative dates
Try changing the format of the cell to "general"
"hotelchambers" wrote: I'm using a simple formula to calculate the days from a start date "=c21-today()" I cannot reverse the formula to get a negative number. Any tips on how to get this number to show up as "-nnn" thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
negative dates
I formatted the cell to number format and got a negative number. As you
probably know all dates in Excel are internally stored as numbers. "hotelchambers" wrote: I'm using a simple formula to calculate the days from a start date "=c21-today()" I cannot reverse the formula to get a negative number. Any tips on how to get this number to show up as "-nnn" thanks. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
negative dates
That was ridiculously simple. :) Thank you both.
On Aug 21, 10:21*pm, Sheeloo wrote: I formatted the cell to number format and got a negative number. As you probably know all dates in Excel are internally stored as numbers. "hotelchambers" wrote: I'm using a simple formula to calculate the days from a start date "=c21-today()" I cannot reverse the formula to get a negative number. Any tips on how to get this number to show up as "-nnn" thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| negative dates in excel | Excel Discussion (Misc queries) | |||
| NEGATIVE DATES IN EXCEL | Excel Worksheet Functions | |||
| negative dates or times are displayed as # # # # | Excel Worksheet Functions | |||
| negative dates or times are displayed as # # # # | New Users to Excel | |||
| NEGATIVE IN BARCKETS AND UK DATES | Excel Discussion (Misc queries) | |||
Linear Mode
