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 Mark Forums Read

Reply
 
Thread Tools Display Modes
  #1  
Old 05-15-2022, 01:30 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
This row



Dim xSum As Long

Change to variant
Reply With Quote
  #2  
Old 05-16-2022, 10:30 AM
Matt C's Avatar
Matt C Matt C is offline Custom SUM functions are ignoring or rounding up decimals Windows 10 Custom SUM functions are ignoring or rounding up decimals Office 97-2003
Advanced Beginner
Custom SUM functions are ignoring or rounding up decimals 		 
Join Date: May 2021
Location: London, UK
Posts: 30
Matt C is on a distinguished road
Default
Quote:
Originally Posted by Purfleet View Post
This row

Dim xSum As Long

Change to variant
That works. Many thanks.
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Hybrid Mode Hybrid Mode


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 07:10 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