Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Custom SUM functions are ignoring or rounding up decimals Custom SUM functions are ignoring or rounding up decimals
Register FAQ

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 05-15-2022, 12:06 PM
Purfleet Purfleet is offline Custom SUM functions are ignoring or rounding up decimals Windows 10 Custom SUM functions are ignoring or rounding up decimals Office 2019
Expert
  
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default
I think the Long Data type is for whole numbers only, try variant or double
Reply With Quote
 

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Ignoring #VALUE in formula calculations NickFazer Excel 7 11-09-2018 03:26 PM
Custom rounding up paulkaye Excel 8 09-03-2016 11:12 PM
Custom SUM functions are ignoring or rounding up decimals Need to restore custom functions from a corrupt ".xlam" file ... gamouning Excel 1 11-12-2015 11:03 AM
Custom formatting code - rounding problem venkys4u Excel 1 08-14-2012 07:45 PM
Custom SUM functions are ignoring or rounding up decimals Merge Field Ignoring Zeros Welshie82 Mail Merge 2 05-04-2012 01:56 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:48 PM.

Contact Us - Privacy Statement - Top

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