Software

Ask something
Discussion Locked

Excel problem

0 helpful
3 replies

by august55

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

One of our users has a form that he uses frequently and when he tries to input some characters in the boxes some of them show up as squares. In the formula box it shows the correct letters and in print it comes out correct, but not in the box itself. Where can we change this? The cells formatting is protected so we can't change anything there. Also, the margin like A4 will show up as a square too instead of the location that it really is.

Thanks for any assistance. Email me at lindafloyd@usa.net

3 replies

by stillatit

This is going to sound silly, but check the font used in that cell. If the font selected is, for example, a symbols font, character positions which do not have actual glyphs in the font will typically show up as a square or rectangle. This can also happen if the font specificed is a "printer font" rather than a truetype font. When the document goes to the printer, the printer automagically substitutes a font it has for any missing font.

by maxwell edison

Greetings,

Sometimes when you export the data from other sources, you will get small squares in excel for characters that excel does not recognize.

You may also be using a font that is not fully recognized.

I'd reload Excel to get accuratefont files, and make sure the font of your data is installed. (Or change the font of the problem data.)

Maxwell

This discussion is closed to new replies.