ExcelBanter - formatting as percentage

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - formatting as percentage (https://www.excelbanter.com/excel-worksheet-functions/270882-formatting-percentage.html)

pat67

formatting as percentage

Hi, I have a cell i am trying to format to show liek this: 83%
Complete

The 83% is coming from a vlookup. The issue is when i concatenate the
vlookup with the word "Complet", the % is shown as a number. i need it
to show as a percent. How would I do that?

All times are GMT +1. The time now is 04:41 AM.