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. |
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