Excel 2007

[plsimmo]

One of my workbooks has been corrupted with the Swedish accounting symbol. I have tried highlighting all the sheets and changing the format to none & resaving. However, it still retains this formatting, when i reopen. I keep having to continuoulsy reformat pivots and other tables.

Does anyone, have a way to resolve this?.
Thanks
Paul

 

[capparfrank]

If you are using tables, sometimes a column can attempt to populate all the rows in a similar fashion independantly from the rest of the sheet. Try highlighting the the entire TABLE column (not the sheet column) and making your changes. Include the header and all rows that are formatted as a table.

Also, have you tried setting the format to General as well as just tweaking the currency symbol?
Are there any macros or automations that could be 'restoring' the formats that you've removed?

 

[plsimmo]

If you are using tables, sometimes a column can attempt to populate all the rows in a similar fashion independantly from the rest of the sheet. Try highlighting the the entire TABLE column (not the sheet column) and making your changes. Include the header and all rows that are formatted as a table.

Also, have you tried setting the format to General as well as just tweaking the currency symbol?
Are there any macros or automations that could be 'restoring' the formats that you've removed?

I have tried changing to general and also highlighting just data table or otherwise that have the issues. However, it still comes back. It is very odd and i have never come across this before. Not sure how the USER managed this, as i asked them, they are at a loss.

There aren't any macro's within this workbook.

The last thing i really want to do is have to rebuild all the workbooks. As you can appreciate. Very frustrating, given i know what the problem is. Just lknow what of getting it to save permanently. Weird!.

Thanks for your response, though.

 

[Lorlai]

Not sure if this will help, but I know that when I get funky Microsoft formatting, copying the data into notepad will sometimes clear it up.

Probably a long shot in your situation, but I thought I'd put my two cents in.


~Lorelai