Fonts

  • Thread starter Thread starter The Old Bloke
  • Start date Start date
T

The Old Bloke

Hi People,

I am doing volunteer work of entering historical data into a spreadsheet. I
OCR the sheets and save into an Excel spreadsheet. This is working well
apart from one problem that I can't solve.

Fairly regularly a cell has a character that is obviously the wrong pitch
and font. However if I highlight the cell, Excel tells me it Times New
Roman, pitch 10. This is what I want it to be but it clearly isn't. If I
delete the contents of the cell and manually retype it it still reverts back
to the wrong font, but Excel still thinks it is Times New Roman 10, but it
clearly isn't! Even the case is wrong. eg I can type a "M" into the cell
and it immediately reverts to "m".

Can anyone help?

Regards
 
To make everything be the same font, if that is what you want,
Ctrl+A to select all cells then change the font from the font drop down.

There are very few fonts that would change the case of a letter,
and you have said the font is "Times New Roman", pitch 10 so
I would check to see if you have an Event Macro installed
for that worksheet. Right click on the sheet tab, view code.
If you have anything besides "Option Explicit" then you have code.
Even though it sounds like you start from scratch with OCR, it
might be possible that you had a template for the sheet.

If you copy and paste that letter into notepad do you see a
small "m" or a capital "M".

What happens if you copy the content of the cell to notepad and
then paste back into the cell. I don't know if there might be
sequences of bytes that might change the font, but if there are
that would change it to plain text. If that changes anything
maybe we can work from there.
 
Hi David,

I revisited the problem, but my wife had discovered a workaround, whereby
she inserted an adjacent blank row, typed a copy and then deleted the row
with the rogue cells. However she missed one, but this did not involve a
case change but a pitch change. Highlight the cell and it says it is Times
New Roman 10. But it is more like 7 or 8. I knew about the Crtl A etc, but
it does not fix these rogue cells (of which I only have one now).

I did the "view code" but nothing as listed.

I copied and pasted the row, with the rogue cell into Word. Word even says
that the rogue cell is pitch 10!

So the problem has workarounds, but I would simply love to know what caused
this as it took hours on the workaround, and I will be doing more of this
work.

I have saved as a spreadsheet this single row with the rogue cell. Can I
email it you?

Regards from Australia

PS I use Excel XP
 
email me the small file. If your email box were not filled
up, I would not have had to post this..
 
You cell is not a small letter, it is formatted as superscript
format, cells, font, superscript
 
Back
Top