Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
frank-e
 
Posts: n/a
Default ½ symbol prints a 2 and Winding square box prints a F

We often share files between staff in a small office. Some of the files have
worksheets with text fields that use the ½ symbol and the square box from the
Windings font set embedded in the text string. When this file is opened on
another machine and printed (sometimes to a different default printer) the ½
gets changed to 2 and the square box gets changed to F. If this file is
saved, everyone else will also see the 2 and F when they open the file. All
computers are set up with the same (default) set of available fonts.

Does anyone know why this might be happening? It gets very frustrating
having to 'proof' these documents every time they get used.

Thanks. Frank-e.
  #2   Report Post  
Posted to microsoft.public.excel.misc
Rob Walton
 
Posts: n/a
Default ½ symbol prints a 2 and Winding square box prints a F

Hi there Frank-e,

I am going to make the assumption that your default font, the one used for
the majority of the spreadsheet is either Arial, Courier New or Times New
Roman (those are the most popular standard fonts in the business world).

After doing some checking in the Windows Character Map utility (Start --
Run -- type "charmap.exe" -- OK), I found that each of these standard
fonts contains the ½ and the –¡, –*, –ª, or –« symbols, depending on which one
you want to use. So, run charmap.exe, select your default font, a quick
scroll will let you find the characters you are looking for, click the
character, press the select button, press the copy button, then go back to
your spreadsheet and paste it where you want it, do this for all of the
occurances of the symbols. Do this on the master spreadsheet, then you will
never have to deal with the Wingdings font again.

The actual problem is the printer. Somewhere in the settings, either on the
printer or on the computer, it says that truetype fonts are to be downloaded
to the printer (or uploaded, whichever way you are thinking). Not all
printers handle fonts the same way, and funny things can happen. Another
workaround is to find all of the settings on everybody's computer and on all
of the printers and ask it to print text as graphics instead of downloading
the fonts, but the fonts I listed above are standard, they will be fully
implemented on every printer, so I would just stop using the Wingdings font.

~Rob Walton

"frank-e" wrote in message
...
We often share files between staff in a small office. Some of the files
have
worksheets with text fields that use the ½ symbol and the square box from
the
Windings font set embedded in the text string. When this file is opened on
another machine and printed (sometimes to a different default printer) the
½
gets changed to 2 and the square box gets changed to F. If this file is
saved, everyone else will also see the 2 and F when they open the file.
All
computers are set up with the same (default) set of available fonts.

Does anyone know why this might be happening? It gets very frustrating
having to 'proof' these documents every time they get used.

Thanks. Frank-e.


  #3   Report Post  
Posted to microsoft.public.excel.misc
frank-e
 
Posts: n/a
Default ½ symbol prints a 2 and Winding square box prints a F

Rob: Thanks a whole bunch. We had assumed it might be the printer (but didn't
know why), and set all the computers to print to a central printer, but this
was just a temporary arrangement. I'll implement the character map solution
which looks like it will work best for us.

Thanks again. Frank-e

"Rob Walton" wrote:

Hi there Frank-e,

I am going to make the assumption that your default font, the one used for
the majority of the spreadsheet is either Arial, Courier New or Times New
Roman (those are the most popular standard fonts in the business world).

After doing some checking in the Windows Character Map utility (Start --
Run -- type "charmap.exe" -- OK), I found that each of these standard
fonts contains the ½ and the –¡, –*, –ª, or –« symbols, depending on which one
you want to use. So, run charmap.exe, select your default font, a quick
scroll will let you find the characters you are looking for, click the
character, press the select button, press the copy button, then go back to
your spreadsheet and paste it where you want it, do this for all of the
occurances of the symbols. Do this on the master spreadsheet, then you will
never have to deal with the Wingdings font again.

The actual problem is the printer. Somewhere in the settings, either on the
printer or on the computer, it says that truetype fonts are to be downloaded
to the printer (or uploaded, whichever way you are thinking). Not all
printers handle fonts the same way, and funny things can happen. Another
workaround is to find all of the settings on everybody's computer and on all
of the printers and ask it to print text as graphics instead of downloading
the fonts, but the fonts I listed above are standard, they will be fully
implemented on every printer, so I would just stop using the Wingdings font.

~Rob Walton

"frank-e" wrote in message
...
We often share files between staff in a small office. Some of the files
have
worksheets with text fields that use the ½ symbol and the square box from
the
Windings font set embedded in the text string. When this file is opened on
another machine and printed (sometimes to a different default printer) the
½
gets changed to 2 and the square box gets changed to F. If this file is
saved, everyone else will also see the 2 and F when they open the file.
All
computers are set up with the same (default) set of available fonts.

Does anyone know why this might be happening? It gets very frustrating
having to 'proof' these documents every time they get used.

Thanks. Frank-e.



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



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

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

About Us

"It's about Microsoft Excel"