Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
djd djd is offline
external usenet poster
 
Posts: 11
Default Euro & British pound symbol issue

I have an Excel file that has a worksheet containing a list of possible
currencies and their symbols. Depending on which currency the user selects
the model displayes the appropriate symbol via vlookup. The Euro and British
pound symbols display properly when the model is run on my PC but not on the
PC of another team member. He gets the bar symbol.

It doesn't appear to be a small font issue because the symbols do no appear
even when zoom is at 100%. The cells where the symbol is displayed are using
the Ariel font and size of 11. I was sent a copy of the file and saw that
there was a weird symbol that looks like an A that prefixed these two
currency symbols on the currency worksheet. I deleted the contents and
picked the correct values from the symbol table. When I sent the file back
to him he got the bar signs again. Any thoughts on what might be different
on his PC versus mine?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,058
Default Euro & British pound symbol issue

Try Ariel Unicode MS
--
Gary''s Student - gsnu200718


"djd" wrote:

I have an Excel file that has a worksheet containing a list of possible
currencies and their symbols. Depending on which currency the user selects
the model displayes the appropriate symbol via vlookup. The Euro and British
pound symbols display properly when the model is run on my PC but not on the
PC of another team member. He gets the bar symbol.

It doesn't appear to be a small font issue because the symbols do no appear
even when zoom is at 100%. The cells where the symbol is displayed are using
the Ariel font and size of 11. I was sent a copy of the file and saw that
there was a weird symbol that looks like an A that prefixed these two
currency symbols on the currency worksheet. I deleted the contents and
picked the correct values from the symbol table. When I sent the file back
to him he got the bar signs again. Any thoughts on what might be different
on his PC versus mine?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
euro symbol mo Excel Discussion (Misc queries) 1 March 12th 07 11:05 AM
euro symbol not displaying in excel Garfield Lindo Excel Discussion (Misc queries) 1 December 14th 06 06:55 PM
euro symbol loses formatting if bold cadiehl Excel Discussion (Misc queries) 2 July 31st 06 02:49 PM
How can I change dollar sybbol to euro symbol? zwerver New Users to Excel 3 January 31st 06 06:55 PM
€ (euro) symbol in Excel charts bananabob Charts and Charting in Excel 1 September 20th 05 01:30 PM


All times are GMT +1. The time now is 12:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"