Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 2-place 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) |