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

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

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

On Tue, 8 May 2007 07:36:00 -0700, Eric wrote:

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


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

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

One way:

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

alternatively,

B1: =A1

format B1 as a percentage with no decimal points.


In article ,
Eric wrote:

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

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

Why use TEXT? In B1 enter =A1 and then format B1 as percent with zero
decimals.
But if you must: =TEXT(A1,"0%")
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Eric" wrote in message
...
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

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

One reason for using TEXT() is if the OP wants to export data to another
application, such as through mail merge to MS Word.
--
David Biddulph

"Bernard Liengme" wrote in message
...
Why use TEXT? In B1 enter =A1 and then format B1 as percent with zero
decimals.
But if you must: =TEXT(A1,"0%")

"Eric" wrote in message
...
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

Thank everyone for suggestions
 

Thank everyone for suggestions
Eric