Hi,

You could try this. This assumed any value less that 1 as a percentage.
Also, the output will be a text value and not a number.

=IF(D23<1,TEXT(D23,"0.00%"),D23)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Gridlock" wrote in message
...
Can anyone offer a solution to the issue of allowing a cell to display a
value in two formats?
I have a spreadsheet and in a cell I have a lookup which checks a table
depending on what is selected from a list, the table has two different
values
Number and Percentage, these values are pulled into a summary screen to
complete a sentance. I can only get the value to display as either a
number
or a percentage. Any suggestions please?

Thanks, Gridlock.