Solved Using summation in Excel 2007

September 9, 2013 at 04:27:45
Specs: Windows Vista
Why does Apr-00 appear when adding cells that have only numbers in them. All the other rows have done it correctly.

See More: Using summation in Excel 2007

Report •


#1
September 9, 2013 at 06:26:05
✔ Best Answer
The cell is probably formatted as a Date.

Since Excel stores Dates and Times as numbers, a cell formatted as Date will display the corresponding Date based on the value in the cell. Change the format to Number and you should be OK.

For a detailed explanation regarding Excel's internal storage of Dates and Times, check out the information found here:

http://www.cpearson.com/excel/datet...

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03


Report •

#2
September 9, 2013 at 09:44:14
Thank you for your help.

Report •

Related Solutions


Ask Question