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

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

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

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

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

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
|
|