format cell custom Number format

D

Dan

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compare dates (re-stated) 1
Custom format string from cell value 2
Custom number format via formula 3
Peculiar default cell format 1
How to get timein hh:mm format 3
Need a number format. 1
how to use the number format 3
Custom format whole number to decimal 7

Top