Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formatting as percentage | Excel Worksheet Functions | |||
Formatting Percentages/LOOKUP using a Percentage | Excel Discussion (Misc queries) | |||
conditional formatting on sales percentage | Excel Worksheet Functions | |||
Percentage formatting | Excel Discussion (Misc queries) | |||
Formatting percentage signs in Excel | Excel Discussion (Misc queries) |