Link to home
Start Free TrialLog in
Avatar of Bright01
Bright01Flag for United States of America

asked on

Suppressing the decimal

EE Pros,

I have a Workbook that allows me to globally change the formatting for Currency.  If you open the Workbook you will see that by selecting a currency, you can change the format in both tabs.  Here's the question, how do I suppress the decimal point to 0?  Right now, if I change it in the cell, and then change the currency, I still get a 2 decimal point answer.

Help!

Thank you in advance,

B.
Suppress-decimals.xlsm
Avatar of [ fanpages ]
[ fanpages ]

Hi B,

There is a VBAProject password associated with the Visual Basic for Applications code within the "Suppress-decimals.xlsm" workbook attached above.

I/we are going to need to know this password to advise on what needs to be changed (within the code) to accommodate your request.

If you have the password, please can you remove it from the workbook & then attach the unprotected version of the file?

If you do not know what the password is, are you able to find it from the author of the code within this workbook?

BFN,

fp.
Avatar of Bright01

ASKER

Ben,

Sorry.  I've removed the Protection.

Thanks!

B.
Suppress-decimalsv2.xlsm
I'm sorry, but there is still a VBProject password applied to the second attachment.

B)ye F)or N)ow,

fp.
BFN,

So sorry.  OK....removed the VBA Password.  Should have complete access now.

B.
Suppress-decimalsv3.xlsm
ASKER CERTIFIED SOLUTION
Avatar of [ fanpages ]
[ fanpages ]

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Perfect!  Why didn't I try that???   Thank you very much.  Seems simple now.

B.
:)

No problem.  I guess it wasn't obvious... I didn't think of trying it before reading the code either!