format cell custom Number format

  • Thread starter Thread starter Dan
  • Start date Start date
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

Peculiar default cell format 1
Conditional Formatting from a group 6
Time Sum in Excel 1
Compare dates (re-stated) 1
Need a number format. 1
Custom format string from cell value 2
Custom Cell Formatting Using % With Dates 2
Format Cells - Custom 1

Back
Top