Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Hi everyone I have a serious problem with my spreadsheet (xlsm)

I don't know how, but cells with default format were converted to currency $, for example C12 has 123, now is $123.00.

How I can change this disaster? This problems happens in all of my sheets. Please tell me something.

share|improve this question
    
you want $123 or 123. – Mowgli Feb 28 '13 at 15:23
1  
XSLM is a macro-enabled workbook. Do you have code that runs each time which could be changing the format? Did you possibly play with the default template? – techturtle Feb 28 '13 at 15:26
    
I want 123. I have a lot of code, and I have a lot of sheets, day to night all my book were corrupted. Rare problem. But to my relief There was a backup. – Rakisbro Mar 1 '13 at 16:15
up vote 1 down vote accepted

Have you tried right clicking on C12 then Format cells. if this worked then select whole sheet and do same.

enter image description here

share|improve this answer
    
but I have many formats in mi sheet, day to night all my book were corrupted, predefined style were signed as currency cell. To my relief, I had saved a backup. Thanks all. – Rakisbro Mar 1 '13 at 16:14
    
Good you did that, but you will face same problem again with the same code. – Mowgli Mar 1 '13 at 16:29
    
It's not about my code, My book is used by seven guys (1year) and nothing happens. Whatever, I was an accident. Thanks. – Rakisbro Mar 1 '13 at 20:26

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .