Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 8th 07, 03:36 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 1,670
Default 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   Report Post  
Old May 8th 07, 03:45 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 5,651
Default 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   Report Post  
Old May 8th 07, 03:47 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 4,624
Default 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   Report Post  
Old May 8th 07, 03:49 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 4,393
Default 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   Report Post  
Old May 8th 07, 05:54 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 8,651
Default 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   Report Post  
Old May 9th 07, 12:36 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 1,670
Default Thank everyone for suggestions

Thank everyone for suggestions
Eric


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
hide values and display a decimal point that fills the cell Sally Excel Worksheet Functions 2 October 10th 06 05:01 AM
Converting 2-place decimal value to floating point decimal number with leading zero Kermit Piper Excel Discussion (Misc queries) 3 March 18th 06 06:20 PM
Display a digit before or after the decimal point in another cell Robert Monks Excel Worksheet Functions 4 December 3rd 05 09:18 AM
FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. SUKYKITTY Excel Discussion (Misc queries) 3 July 6th 05 01:50 PM
Why am I getting .+ when I hit the decimal point? ato_dad Excel Discussion (Misc queries) 1 May 31st 05 06:52 PM


All times are GMT +1. The time now is 11:25 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017