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

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.

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

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.