Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #8  
Old 01-14-2016, 05:59 AM
Debaser's Avatar
Debaser Debaser is offline Addition Formula is Giving a Date!!! Windows 7 64bit Addition Formula is Giving a Date!!! 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
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Addition Formula is Giving a Date!!! Formula to return a date caz46 Excel 3 04-15-2015 08:59 AM
Addition Formula is Giving a Date!!! Date specific formula Query Mukiwi Excel 4 03-20-2014 06:33 AM
Addition Formula is Giving a Date!!! VLookup is giving me #N/A error, help with data or formula? ladygogo78 Excel 3 10-22-2012 12:28 AM
Index Addition Leaves Hidden Codes On SQLUSA Word 3 07-23-2012 02:58 AM
Addition Formula is Giving a Date!!! Need a date formula MPAVLAS Excel 3 08-12-2010 10:04 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:19 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft