Need help with format number

  • Thread starter Thread starter agpaco
  • Start date Start date
A

agpaco

In 2003, I need a way to: if de number don't have €, he put ZAR. But if have
€, he don´t modify. I think the only way is creating a new number format, but
I don't no how.
 
Thank for your help. I first think to use If, but how can detect the euro
format?
 
You must log in or register to reply here.

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

Conditional Format Excel 2007 6
Default format of cell comments 4
Conditional formatting with a prompt and new email message 2
Number formats default to dates 1
Counting multiple memberships 1
Numbers showing Up Centered in Cell ? 1
Conditional Formatting 6
Hide Formula & Allow Copy 1

Back
Top