Excel 2007 format as percent inside quotation 1

[PRMiller2]

I have the value 73.27% in cell E19 of a spreadsheet named "data." On my report spreadsheet, I have a cell that I would like to display as follows: "73.27% of data..." So far, the formula in my cell is as follows:

="∙ " & data!E19 & " of data..."

My question is, how can I format the data!E19 statement to display as a percentage with two decimal places?

Thanks,
Paul

 

[SkipVought]

hi,
[tt]
=TEXT(data!E19,"0.00%") & " of data..."
[/tt]



Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[PRMiller2]

OHHHHHH!!!! (Smacks forehead with hand). Thanks!

 

[combo]

You can use custom format and preserve value (=E19), the code for format:
[tt]0,00%" of data..."[/tt]

combo