Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / December 2007

Tip: Looking for answers? Try searching our database.

Currency problem with SFr.

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Nick Turney - 04 Dec 2007 11:34 GMT
Hi All,
odd problem this one. One of my users is updating an existing spreadsheet.
We use Office 2003 with SP3. He has a list of figures (5 off) all set to
different currency's, one of which is £ (british pound). However, all is fine
untill he gets to the last one, and sets it to SFr. (Swiss Franc). Now the £
symbol from above comes up showing as £FR.

This now happens on all documents in Excel, untill we close Excel and reopen
it. It will then work correctly on new sheets, untill we either create a new
sheet with the above details in, or reopen that sheet.

I can replicate the issue on other computers, with other sheets, both new
and old.

Any idea's
Cheers
Nick
Bernard Liengme - 04 Dec 2007 13:04 GMT
I cannot reproduce this. Please spell out the steps needed to get the
problem to appear.
Feel free to send me (private email not to the newsgroup) a file with this
problem
best wishes
Signature

Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

> Hi All,
> odd problem this one. One of my users is updating an existing spreadsheet.
[quoted text clipped - 17 lines]
> Cheers
> Nick
Bernard Liengme - 06 Dec 2007 13:04 GMT
It turns out Nick had a corrupt file that somehow 'attacked' the Regional
Settings!
Signature

Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

> Hi All,
> odd problem this one. One of my users is updating an existing spreadsheet.
[quoted text clipped - 17 lines]
> Cheers
> Nick

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.