Bright01
asked on
Controlling the Decimal Places
EE Pros,
I have Two Worksheets in a Workbook (attached) that change Currency Formatting when a new Currency is selected. A table controls the decimal points on the results. I have some fields that require 2 Decimals and some that require -0- (i.e. numbers ranging from .15 to 150000000. So you see the need for controlling the decimal points at the end result cell.
I'm hoping there is a simple way to do this but I have tried changing the Cell Formatting (which reverts to the table when the currency changes). Any ideas?
B.
Suppress-decimalsv4.xlsm
I have Two Worksheets in a Workbook (attached) that change Currency Formatting when a new Currency is selected. A table controls the decimal points on the results. I have some fields that require 2 Decimals and some that require -0- (i.e. numbers ranging from .15 to 150000000. So you see the need for controlling the decimal points at the end result cell.
I'm hoping there is a simple way to do this but I have tried changing the Cell Formatting (which reverts to the table when the currency changes). Any ideas?
B.
Suppress-decimalsv4.xlsm
Sorry. I had a question here but I figured it out. Will get back to you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sorry for the delay; Let me try this and get back with you in 24 hrs. On the road....
Thank you,
B.
Thank you,
B.
You may still be unpacking but did you get a chance to test this?
ASKER
MartinLiss,
I am so sorry to have taken so long in testing this. It worked perfectly! I just got in to South Africa and it's the only excuse I have for not getting back with you sooner. Thank you so much! I may author a slightly different question about how to address the same requirement on a different "sheet".
Thanks again,
B.
I am so sorry to have taken so long in testing this. It worked perfectly! I just got in to South Africa and it's the only excuse I have for not getting back with you sooner. Thank you so much! I may author a slightly different question about how to address the same requirement on a different "sheet".
Thanks again,
B.
You're welcome and I'm glad I was able to help.
Marty - MVP 2009 to 2013
Marty - MVP 2009 to 2013