AOA Forums AOA Forums AOA Forums Folding For Team 45 AOA Files Home Front Page Become an AOA Subscriber! UserCP Calendar Memberlist FAQ Search Forum Home


Go Back   AOA Forums > Software > OS, Software, Firmware, and BIOS


Reply
 
LinkBack Thread Tools Rate Thread
  #1 (permalink)  
Old 5th February, 2003, 10:51 AM
Con's Avatar
Con Con is offline
Member
 
Join Date: June 2002
Posts: 450
Send a message via AIM to Con

INSANE: Excel Currency Formatter Issue! (Im Stumped)

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:
Attached Thumbnails
INSANE: Excel Currency Formatter Issue! (Im Stumped)-currencyss.gif  
__________________
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 5th February, 2003, 10:53 AM
Con's Avatar
Con Con is offline
Member
 
Join Date: June 2002
Posts: 450
Send a message via AIM to 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
Attached Thumbnails
INSANE: Excel Currency Formatter Issue! (Im Stumped)-formatss.gif  
__________________
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 5th February, 2003, 11:46 AM
Chief Systems Administrator
 
Join Date: September 2001
Location: Europe
Posts: 13,075

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
__________________
Any views, thoughts and opinions are entirely my own. They don't necessarily represent those of my employer (BlackBerry).
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 5th February, 2003, 01:59 PM
Con's Avatar
Con Con is offline
Member
 
Join Date: June 2002
Posts: 450
Send a message via AIM to 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
__________________
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5 (permalink)  
Old 5th February, 2003, 02:06 PM
Chief Systems Administrator
 
Join Date: September 2001
Location: Europe
Posts: 13,075

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
__________________
Any views, thoughts and opinions are entirely my own. They don't necessarily represent those of my employer (BlackBerry).
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #6 (permalink)  
Old 5th February, 2003, 02:26 PM
Con's Avatar
Con Con is offline
Member
 
Join Date: June 2002
Posts: 450
Send a message via AIM to 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.
__________________
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel vulnerable to zero-day attack Gizmo Data Security 0 6th February, 2007 04:17 PM
Excel % Comparison skool h8r Random Nonsense! 1 9th January, 2007 05:29 PM
Could this be a 3.13 driver issue? Im stumped. $ilent$uicide Graphics and Sound cards; Speakers and other Peripherals 0 14th January, 2004 05:13 PM
<insane laughter>Muhahaha</insane laughter> prat ThunderRd's AOA FOLDING@HOME Team 6 15th October, 2003 02:07 AM
VBA and Excel Rackne Random Nonsense! 0 11th December, 2001 02:57 AM


All times are GMT +1. The time now is 09:16 PM.


Copyright ©2001 - 2010, AOA Forums
Don't Click Here Don't Click Here Either

Search Engine Friendly URLs by vBSEO 3.3.0