Text Formats In Formals

[Minitman]

Greetings.

I am trying to get this output:

8.25% Sales Tax

with this formula:

=Enter!AL42&" Sales Tax"

What I get is"

..0825 Sales Tax

Where Enter!AL42 is .0825 formatted as percentage to 2 decimal places.
Is there a way to format the cell reference in this formula as
percentage to 2 decimal places?

Any help would be most appreciated.

TIA

-Minitman

 

[Frank Kabel]

Hi
try
=TEXT(Enter!AL42,"0.00%") & " Sales Tax"

 

[Dave R.]

=Enter!AL42*100&"% Sales Tax"

 

[Dave R.]

oops, not to 2 decimal places.
It's covered, but
=ROUND(Enter!AL42*100,2)&"% Sales Tax"
work too.

 

[Minitman]

Hey Frank,

That is exactly what I was looking for.

Thank you.

-Minitman

 

[Minitman]

Hey Dave,

This looks like good, although Franks solution is just a little bit
better.

I do appreciate the reply.

-Minitman