| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
formula to add numbers gives a date like 10/12/27 instead of sum
Trying to add two numbers in Excel. Instead of the total I get a date in the
cell such as 10/12/27 . I have checked and checked and I am sure that I am entering the formula to add the cells correctly. There must be somethjing else embedded in the cell. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
formula to add numbers gives a date like 10/12/27 instead of sum
What happens if you format the cell as general?
-- Regards, Peo Sjoblom Portland, Oregon "Giaosi" wrote in message ... Trying to add two numbers in Excel. Instead of the total I get a date in the cell such as 10/12/27 . I have checked and checked and I am sure that I am entering the formula to add the cells correctly. There must be somethjing else embedded in the cell. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trending Formula Results by Date | Excel Worksheet Functions | |||
| Conditional formula date | Excel Worksheet Functions | |||
| Year-to-date year to date formula | Excel Worksheet Functions | |||
| NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
| Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions | |||
Linear Mode
