How to display percentage with 0 decimal point by Text function?

E

Eric

Does anyone know how to use Text function to display percentage with 0
decimal point? such as
0.5 displays in cell A1, in cell B1, how to write the code Text(A1, ???) in
order to display 50% in cell B1?
Thank for any suggestions
Eric
 
R

Ron Rosenfeld

Does anyone know how to use Text function to display percentage with 0
decimal point? such as
0.5 displays in cell A1, in cell B1, how to write the code Text(A1, ???) in
order to display 50% in cell B1?
Thank for any suggestions
Eric
Click to expand...


=TEXT(A1,"0%")
--ron
 
J

JE McGimpsey

One way:

B1: =TEXT(A1,"0%")

alternatively,

B1: =A1

format B1 as a percentage with no decimal points.
 
Top