View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
pat67 pat67 is offline
external usenet poster
 
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