correct I'm afraid - custom formats allow you to alter the formatting
of the number (so you can include symbols, change decimals, format the
date as month etc) but you cannot change the format of the cell (that
would be custom cell format, not custom number format) and such an
option does not exist
Louise wrote:
So is this not possible to do via Format, Cells, Custom?
Thank you.
Louise

"Gary''s Student" wrote:

Hi Louise:

NumberFormats and font characteristics are separate:


Sub Macro1()
Selection.NumberFormat = "yy-mm-dd"
With Selection.Font
.FontStyle = "Bold"
.Size = 12
End With
End Sub
--
Gary''s Student


"Louise" wrote:

Hi all

When creating a custom number format, how would you ask it to show text in
'bold and size 12 font'?

Thank you

Louise