Microsoft Office Forums - View Single Post - [Solved] Custom SUM functions are ignoring or rounding up decimals

Thread: [Solved] Custom SUM functions are ignoring or rounding up decimals

View Single Post

Old

05-15-2022, 01:19 PM

Matt C

Matt C is offline

Matt C uses Windows 10

Windows 10 Matt C uses Office 97-2003

Matt C uses Office 97-2003

Office 97-2003

Advanced Beginner

The original poster

Join Date: May 2021

Location: London, UK

Posts: 30

Matt C is on a distinguished road

Default

Quote:

Originally Posted by Purfleet

View Post

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.

Reply With Quote