When I try to format columns from number format to currency format, I dont succeed on the first try. I need to click the format settings a 2nd time in order to succeed. Please advise me what I can do in order to make it format to currency on the first try. I am using Office 2007

link|improve this question

65% accept rate
All workbooks do this? What have you tried? – techie007 Mar 4 '11 at 5:13
Please provide a step-by-step procedure that shows this problem. Then we can help you solve it. – Wayne Johnston Mar 5 '11 at 3:31
feedback

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown

Browse other questions tagged or ask your own question.