I have had this issue on multiple versions of Excel. 2003 and 2007. Can't remember if it happened on 97. Am currently running 2007 on both an XP and a 7 platform (different computers).
When I select a group of cells (column, for instance) and try to format them for "Currency" it usually will initially format them to "Number". I will then have to select Format again and choose "Currency" and then it will change them to currency.
Why is it doing this and is there a way I can get it to work correctly the first time through?
Disclaimer: I just created a new document and experimented with three columns. Column A had no data, Column B had numerical data, Column C had numerical and text data. And it worked properly on all three. AAAArrrrgghhhh!!!!
Thank you.
-dockdude
Bookmarks