???
=IF(D4<1,TEXT(D4,"0.00%"),TEXT(D4,"#"))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Gridlock" wrote in message
...
I'm trying to find a way of displaying the content of a cell as either a
number or a percentage depending on the output from a lookup. I'm
struggling
to find a way to do this in Excel 2003. Can you help please?