Bright01
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
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
ASKER
I'm sorry, but there is still a VBProject password applied to the second attachment.
B)ye F)or N)ow,
fp.
B)ye F)or N)ow,
fp.
ASKER
BFN,
So sorry. OK....removed the VBA Password. Should have complete access now.
B.
Suppress-decimalsv3.xlsm
So sorry. OK....removed the VBA Password. Should have complete access now.
B.
Suppress-decimalsv3.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Perfect! Why didn't I try that??? Thank you very much. Seems simple now.
B.
B.
:)
No problem. I guess it wasn't obvious... I didn't think of trying it before reading the code either!
No problem. I guess it wasn't obvious... I didn't think of trying it before reading the code either!
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.