As long as you DON'T try to do any calculations with cell B5 (for the
reason explained by Paul) you would use the following formula in cell
B5:
=IF(B1="USD K",CONCATENATE("USD ",TEXT(B11,"#,###")),CONCATENATE("INR
",TEXT(B10,"#.#")))
If you do need to do calculations with the value in cell B5 I
o
get it displayed the way you want it.
Paul
From: Radhe Sham L
To: excel-mac...@googlegroups..com
Sent: Friday, October 9, 2009 7:09:03 AM
Subject: $$Excel-Macros$$ Re: Managing decimal places
Hi ,
I have a requirement for a solution regarding the display of
Hi ,
I have a requirement for a solution regarding the display of decimal place
I have a report which displays data in 2 currencies - USD K & INR Crores
Based on the Currency selected from the drop box. The Value in the
respective currency is required to be displayed in the same cell
for exampl
