Home 
Search 
Today's Posts 
#1




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 
#2




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 
#3




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 
#4




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 
#5




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 
#6




Thank everyone for suggestions
Thank everyone for suggestions
Eric 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
hide values and display a decimal point that fills the cell  Excel Worksheet Functions  
Converting 2place decimal value to floating point decimal number with leading zero  Excel Discussion (Misc queries)  
Display a digit before or after the decimal point in another cell  Excel Worksheet Functions  
FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT.  Excel Discussion (Misc queries)  
Why am I getting .+ when I hit the decimal point?  Excel Discussion (Misc queries) 