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