Custom SUM functions are ignoring or rounding up decimals

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Custom SUM functions are ignoring or rounding up decimals

FAQ

Thread Tools

Display Modes

05-15-2022, 01:19 PM

Matt C

Windows 10 Custom SUM functions are ignoring or rounding up decimals

Office 97-2003

Advanced Beginner

Join Date: May 2021

Location: London, UK

Posts: 30

Quote:

Originally Posted by Purfleet

I think the Long Data type is for whole numbers only, try variant or double

Thanks, Purfleet. Would you mind posting an example of the code line I need to add/amend? I'm still feeling my way through this area of VBA programming.

« 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
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
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 12:36 AM.