Not with the custom format. Why do you want to so it via the custom format? Maybe there is an easy other solution for what you're
trying to achieve.

--
Kind regards,

Niek Otten

"Louise" wrote in message ...
| Thank you for your reply.
| Is it possible then to format the NUMBERS into size 12 font and bold?
| Thanks again.
| Louise
|
| " wrote:
|
| 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
|
|