Thread: [Solved] Addition Formula is Giving a Date!!!
View Single Post
 
Old 01-14-2016, 05:59 AM
Debaser's Avatar
Debaser Debaser is offline Windows 7 64bit Office 2010 32bit
Competent Performer
  
Join Date: Oct 2015
Location: UK
Posts: 221
Debaser will become famous soon enough
Default
It's not a date formula. The cell is formatted to display dates. All you needed to do was to select the cell with the SUM formula in it, press Ctrl+1 (or right-click it and choose Format Cells) and change the format on the Number tab from Date to something else.
Reply With Quote