INSANE: Excel Currency Formatter Issue! (Im Stumped)

[Con]

Hey guys, Ive got a very interesting/confusing issue in microsoft excel 2000.

In my Windows XP Regional Settings, I have set Currenct to show as £'s. Now, when i go into MS Excel, and select a cell with numeric data in it, and then click the currency button, it formats with dollars as shown in this screenshot:

[Con]

Now, to complicate things even further for you! I did some research and have come to the conclusion that the currency formatter button definitely gets its settings from the regional settings, so why is it seeing it as dollars?

I can come to this conclusion, because when I right click cells with numeric data in them, and select format cells, then select currency as shown in the screenshot below, i get it all in pounds! So where is the difference coming from? is there some unknown registry entry that im missing here? I would love an answer to this because i have this issue on 200 machines @!!

Conrad

[Áedán]

The Currency Style doesn't necessarily take it's settings from XP's regional settings. It can be overridden by the settings in the default templates for workbooks or worksheets. These are book.xlt or sheet.xlt respectively.

Typically these are stored under the profiles directory. (Example c:\Documents and Settings\username\Application Data\Microsoft\Templates)

Áedán

[Con]

I am indeed using an excel template thats downloaded from the server on login... its book.xlt in c:\program files\microsoft office\office\xlstart

Now, any ideas as to WHERE in the template it is specified?

Con

[Áedán]

Open the template, then try: Format -> Style. Select the Currency Style (I have two?), then hit Modify. See how that's set up.

Other than that, I'm not really sure. I'm pretty sure that Excel picks up some of it's settings from the templates.

Áedán

[Con]

pld you

I was tinkering about and deleted the template from xlstart and it was giving me pounds as i wanted it to =) i then modified book.xlt as you suggested i do, and popped it back in xlstart.

Im very happy now =) this has taken ages to resolve! One more question on where XP picks the .pol files up from the server still unanswered and im gettin it in the neck, think ill give that post a bump whilst ur online

Cheers Áedán

Con.