Hi -
I am losing zeros after the decimal point when I convert currency and percentage numbers to text.
Ex.
Cell TAM!$AA$37 is $25.00 (number formatted as currency, two decimal places)
Formula to convert to text that has necessary formatting:
=TEXT(TAM!$AA$37,"$##.##")
Result: $25.
Any ideas on how I can keep my placeholder zeros when converting from number to text?
Thanks
I am losing zeros after the decimal point when I convert currency and percentage numbers to text.
Ex.
Cell TAM!$AA$37 is $25.00 (number formatted as currency, two decimal places)
Formula to convert to text that has necessary formatting:
=TEXT(TAM!$AA$37,"$##.##")
Result: $25.
Any ideas on how I can keep my placeholder zeros when converting from number to text?
Thanks