xlxs formats as currency as dollars when you open the file

[Malcolm_McIvor]

I format a cell currency as £ and save it in the new xlxs format. When I open up the file again the cell currency is now formatted as $ again

Any ideas anyone ?

 

[JE McGimpsey]

I format a cell currency as £ and save it in the new xlxs format. When I open
up the file again the cell currency is now formatted as $ again <br><br>Any
ideas anyone ?

Hmm... I can't reproduce that here.

When you say "format a cell currency as £" are you talking about a
custom format, or are you changing the Currency style?

Does the same thing happen if you save it as an .xls file?

 

[Duncan Moore]

Create a spreadsheet and format the values as £ from the FORMAT CELLS &gt; NUMBER &gt; CURRENCY option. Save and reload. All values are in $ from the Custom menu.

 

[Duncan Moore]

Still have this problem; however it works if you use .xls

 

[Guest]

I get this same problem and cant seem to fix it. I get this whether I use the currency option or if I use custom to do it. Is really becoming a pain and I cant find any way around this problem. Hoping for some ideas?

 

[fazbah]

Re: xlxs formats as currency as dollars when you open the file
I have this problem with new spreadsheets created in office 2008.
But worksheets imported from my PC are ok.
The only way i can keep the £ sign is to format using the currency icon on the toolbar.
What a pain!!!

 

[Gradivus]

Yes, exactly the same problem here. New xlxs documents always revert to $, but converted xls documents retain the £ symbol.

Admittedly, it's a minor problem in the grand scheme of things, but very annoying nonetheless.

 

[Peter_S]

I too have this problem on my Mac - its driving me nuts! I have no answers, only adding to the volume, having tried everything. It affects my old 2004 versions too, once converted.

 

[kevnash]

I to am getting this problem, it is really annoying me, cant find anything on the internet to help, will there be an update Microsoft can bring out to fix it?

 

[Pat McMillan]

Yes. We are currently working on a fix for this problem.

 

[Andrew_M]

This is a really annoying problem, especially on complex sheets with differing formats.

Please find a fix quickly and make it available on an automatic update.

 

[benraine]

This problem is driving me up the wall, every time I need to copy a
spreadsheet to my workplace PCs via a memory stick all the currency
symbols have changed to $ I have to re-format it back to the £ symbol,
which can take an age. Aaaargh. Hurry up and fix it. Please.

 

[Jim Gordon MVP]

This problem is driving me up the wall, every time I need to copy a
spreadsheet to my workplace PCs via a memory stick all the currency
symbols have changed to $ I have to re-format it back to the £ symbol,
which can take an age. Aaaargh. Hurry up and fix it. Please.

Hi,

As a temporary work-around have you tried NeoOffice? It's free
http://www.neooffice.org/

-Jim