Manipulating the display/format of a numeric value inserted into a text cell in Excel

Bill Golden
Bill Golden used Ask the Experts™
on
I now have a cell which looks like this...

=IF(B43<>"","Value of "&B43& "'s " &B44& "% Ownership Interest","You must enter a name in B43")

I need the value of B44 to always display with two decimals, even when the value of B44 is xx.00
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Finance Analyst
Commented:
Replace B44 with:

TEXT(B44,"0.00")

Thanks
Rob H
Bill GoldenExecutive Managing Member

Author

Commented:
Once again, perfect!

One more to go....

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial