Hi: I need to round a formula from a decimal to a percent here is the
foemula,=VLOOKUP(D10,Customers,9)&"/"&VLOOKUP(D10,Customers,10,FALSE)&"
"&VLOOKUP(D10,Customers,11,FALSE)&" "&VLOOKUP(D10,Customers,12,FALSE) I need
to put the percent in the first vlookup it is now showing as a decimal but I
want to round it to 2 decimal places and have a percent sign. any help would
be greatly appriciated.