Determine actual font used instead of custom font

[alevy]

I have an Excel workbook formatted with a custom font that is not installed on my computer. How can I determine what font Excel is actually rendering the text in?

It is not my default Excel font (Calibri) because when I change the font to Calibri, the appearance of the text changes.

It is not the actual font indicated by the Format Cells dialog because if I do install that font, the appearance of the text changes (and fonts cannot be embedded in Excel workbooks).

 

[johnnyL]

@alevy just for giggles see what the following produces as a result:

insert the following function code into a module:

Function WhichFontIs(Cel As Range)
    WhichFontIs = Cel.Font.Name
End Function

Then on your sheet with the 'mysterious' font, In a blank cell insert the following formula:

=whichfontis(A1)

A1 being a cell that has a 'mysterious' font.

See what the result is to that.

 

[Fluff]

AFAIK it's not possible to tell which font is actually being used, only which font it should be.

 

[johnnyL]

Hey @Fluff, could you explain what you mean by 'should be'?

 

[Fluff]

It's the font that the cell format specifies.