I am working with a macro-enabled workbook that contains many sheets and all of a sudden every number figure is converted to the accounting format. Filters that contain numbers are now $2.00 instead of just '2' so i am not even able to run my macro. I definitely didn't highlight all of these cells on all sheets and select the accounting format. Anyone ever had this issue and know of a solution. Thanks.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
every number turned to accounting format
- Thread starter avandever
- Start date
Similar threads
- Question
