format cell custom Number format
 

what custom number format can I use to be % if there is a number but General
if the is not.

So 0.02 will come as 2.0%
But 0 will come as nothing

Thanks,
Dan

format cell custom Number format
 

0.0%;-0.0%;0
--
David Biddulph

"Dan" wrote in message
...
what custom number format can I use to be % if there is a number but
General
if the is not.

So 0.02 will come as 2.0%
But 0 will come as nothing

Thanks,
Dan

format cell custom Number format
 

This'll do it...
0.0%_);[Red](0.0%);_(* ""??_);_(@_)
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"Dan" wrote:

what custom number format can I use to be % if there is a number but General
if the is not.

So 0.02 will come as 2.0%
But 0 will come as nothing

Thanks,
Dan