Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 4th 11, 02:10 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2009
Posts: 48
Default formatting a percentage in a cell

I am trying to show this in a cell: 83% Complete

The 83% is from a vlookup and I concatenate with the word "Complete".
Problem is that when i do this the % becomes the actual value
0.832458... How can i make it so it stays a percentage?

Thanks

  #2   Report Post  
Old August 4th 11, 02:45 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2010
Posts: 1,045
Default formatting a percentage in a cell

On Thu, 4 Aug 2011 06:10:40 -0700 (PDT), pat67 wrote:

I am trying to show this in a cell: 83% Complete

The 83% is from a vlookup and I concatenate with the word "Complete".
Problem is that when i do this the % becomes the actual value
0.832458... How can i make it so it stays a percentage?

Thanks


Something like:

=text(vlookup_result, "0%") & " Complete"

or, in the cell with the Vlookup formula, just Custom Format the cell as

Format/Numbers/Custom
Type: 0%" Complete"

This latter has the possible advantage that the contents of the cell is still a number.
  #3   Report Post  
Old August 18th 11, 03:44 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2009
Posts: 48
Default formatting a percentage in a cell

On Aug 4, 9:45*am, Ron Rosenfeld wrote:
On Thu, 4 Aug 2011 06:10:40 -0700 (PDT), pat67 wrote:
I am trying to show this in a cell: 83% Complete


The 83% is from a vlookup and I concatenate with the word "Complete".
Problem is that when i do this the % becomes the actual value
0.832458... * How can i make it so it stays a percentage?


Thanks


Something like:

=text(vlookup_result, "0%") & " Complete"

or, in the cell with the Vlookup formula, just Custom Format the cell as

Format/Numbers/Custom
Type: *0%" Complete"

This latter has the possible advantage that the contents of the cell is still a number.


I actually did it like your first suggestion. Thanks
  #4   Report Post  
Old August 18th 11, 06:58 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2010
Posts: 1,045
Default formatting a percentage in a cell

On Thu, 18 Aug 2011 07:44:26 -0700 (PDT), pat67 wrote:

On Aug 4, 9:45*am, Ron Rosenfeld wrote:
On Thu, 4 Aug 2011 06:10:40 -0700 (PDT), pat67 wrote:
I am trying to show this in a cell: 83% Complete


The 83% is from a vlookup and I concatenate with the word "Complete".
Problem is that when i do this the % becomes the actual value
0.832458... * How can i make it so it stays a percentage?


Thanks


Something like:

=text(vlookup_result, "0%") & " Complete"

or, in the cell with the Vlookup formula, just Custom Format the cell as

Format/Numbers/Custom
Type: *0%" Complete"

This latter has the possible advantage that the contents of the cell is still a number.


I actually did it like your first suggestion. Thanks



Glad to help. Thanks for the feedback.


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
formatting as percentage pat67 Excel Worksheet Functions 0 August 4th 11 02:00 PM
Formatting Percentages/LOOKUP using a Percentage eed Excel Discussion (Misc queries) 1 September 10th 09 07:07 AM
conditional formatting on sales percentage Loadmaster Excel Worksheet Functions 1 August 17th 09 03:11 AM
Percentage formatting HJ Excel Discussion (Misc queries) 1 March 17th 06 03:07 PM
Formatting percentage signs in Excel Romany Excel Discussion (Misc queries) 3 June 1st 05 07:02 PM


All times are GMT +1. The time now is 10:40 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017