On Mon, 20 Aug 2007 12:34:28 -0600, "Werner R Schilling"
<lobo@spamfence.net> wrote:

> Sorry, this may be somewhat off topic:
>
> Temporary I have to use a notebook that is not mine.
>
> On my notebook, when I format a cell in Excel to the currency "Spanish
> (Costa Rica)" appears the correct symbol that is somewhat similar to a
> C with a double slash. I use Win XP SP2 and Excel 2002.
>
> On the other Notebook it is also Win XP SP2, but Excel 2000. When I
> try to format the same, in the format menu I see the correct symbol on
> screen, but on the spreadsheet I get only a rectangle on the screen as
> well as on the printed sheet. On former formatted spreadsheets I see
> the same rectangle for the currency instead of the symbol. -- In the
> country settings for the computer I can see the correct symbol for the
> Costa Rican currency - on the screen.
>
> Where is that symbol set for currencies stored and why doesn't Excel
> use it correctly? (Excel doesn't use the symbol for the Mongolian
> currency neither - but that concerns me much less ;-) )
>
> Thanks for your patience and help!
>
> Werner

You are aware that some fonts do have certain special characters,
while others don't?
Especially fonts from us-providers sometimes are somewhat "localized"
and leave out certain characters in use only in foreign languages...
Maybe your "preview" uses a different font than your actual document -
Windows country setting most probably uses a font supplied by
Microsoft, where most MS-supplied fonts are comparatively "complete" -
your Spreadsheet might use a totally different font - worse even: if
you designed the spreadsheet on a different computer, it's possible
that the font you used on THAT computer isn't available in THIS
computer and substituted by another one...

Windows XP's Accessory "Character Map" might help you finding out if a
certain font includes whatever character you want to use - or for that
matter what different font might include what you're looking for...

T.C.