ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   formula to add numbers gives a date like 10/12/27 instead of sum (https://www.excelbanter.com/new-users-excel/67226-formula-add-numbers-gives-date-like-10-12-27-instead-sum.html)

Giaosi

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.

Peo Sjoblom

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.




All times are GMT +1. The time now is 08:14 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com