software

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 = quot;yy-mm-ddquot;
With Selection.Font
.FontStyle = quot;Boldquot;
.Size = 12
End With
End Sub
--
Gary''s Studentquot;Louisequot; wrote:

gt; Hi all
gt;
gt; When creating a custom number format, how would you ask it to show text in
gt; 'bold and size 12 font'?
gt;
gt; Thank you
gt;
gt; Louise

So is this not possible to do via Format, Cells, Custom?
Thank you.
Louise

quot;Gary''s Studentquot; wrote:

gt; Hi Louise:
gt;
gt; NumberFormats and font characteristics are separate:
gt;
gt;
gt; Sub Macro1()
gt; Selection.NumberFormat = quot;yy-mm-ddquot;
gt; With Selection.Font
gt; .FontStyle = quot;Boldquot;
gt; .Size = 12
gt; End With
gt; End Sub
gt; --
gt; Gary''s Student
gt;
gt;
gt; quot;Louisequot; wrote:
gt;
gt; gt; Hi all
gt; gt;
gt; gt; When creating a custom number format, how would you ask it to show text in
gt; gt; 'bold and size 12 font'?
gt; gt;
gt; gt; Thank you
gt; gt;
gt; gt; 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:
gt; So is this not possible to do via Format, Cells, Custom?
gt; Thank you.
gt; Louise
gt;
gt; quot;Gary''s Studentquot; wrote:
gt;
gt; gt; Hi Louise:
gt; gt;
gt; gt; NumberFormats and font characteristics are separate:
gt; gt;
gt; gt;
gt; gt; Sub Macro1()
gt; gt; Selection.NumberFormat = quot;yy-mm-ddquot;
gt; gt; With Selection.Font
gt; gt; .FontStyle = quot;Boldquot;
gt; gt; .Size = 12
gt; gt; End With
gt; gt; End Sub
gt; gt; --
gt; gt; Gary''s Student
gt; gt;
gt; gt;
gt; gt; quot;Louisequot; wrote:
gt; gt;
gt; gt; gt; Hi all
gt; gt; gt;
gt; gt; gt; When creating a custom number format, how would you ask it to show text in
gt; gt; gt; 'bold and size 12 font'?
gt; gt; gt;
gt; gt; gt; Thank you
gt; gt; gt;
gt; gt; gt; LouiseThank you for your reply.
Is it possible then to format the NUMBERS into size 12 font and bold?
Thanks again.
Louise

quot; wrote:

gt; correct I'm afraid - custom formats allow you to alter the formatting
gt; of the number (so you can include symbols, change decimals, format the
gt; date as month etc) but you cannot change the format of the cell (that
gt; would be custom cell format, not custom number format) and such an
gt; option does not exist
gt; Louise wrote:
gt; gt; So is this not possible to do via Format, Cells, Custom?
gt; gt; Thank you.
gt; gt; Louise
gt; gt;
gt; gt; quot;Gary''s Studentquot; wrote:
gt; gt;
gt; gt; gt; Hi Louise:
gt; gt; gt;
gt; gt; gt; NumberFormats and font characteristics are separate:
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; Sub Macro1()
gt; gt; gt; Selection.NumberFormat = quot;yy-mm-ddquot;
gt; gt; gt; With Selection.Font
gt; gt; gt; .FontStyle = quot;Boldquot;
gt; gt; gt; .Size = 12
gt; gt; gt; End With
gt; gt; gt; End Sub
gt; gt; gt; --
gt; gt; gt; Gary''s Student
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;Louisequot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Hi all
gt; gt; gt; gt;
gt; gt; gt; gt; When creating a custom number format, how would you ask it to show text in
gt; gt; gt; gt; 'bold and size 12 font'?
gt; gt; gt; gt;
gt; gt; gt; gt; Thank you
gt; gt; gt; gt;
gt; gt; gt; gt; Louise
gt;
gt;

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

quot;Louisequot; gt; 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
|
| quot; wrote:
|
| gt; correct I'm afraid - custom formats allow you to alter the formatting
| gt; of the number (so you can include symbols, change decimals, format the
| gt; date as month etc) but you cannot change the format of the cell (that
| gt; would be custom cell format, not custom number format) and such an
| gt; option does not exist
| gt; Louise wrote:
| gt; gt; So is this not possible to do via Format, Cells, Custom?
| gt; gt; Thank you.
| gt; gt; Louise
| gt; gt;
| gt; gt; quot;Gary''s Studentquot; wrote:
| gt; gt;
| gt; gt; gt; Hi Louise:
| gt; gt; gt;
| gt; gt; gt; NumberFormats and font characteristics are separate:
| gt; gt; gt;
| gt; gt; gt;
| gt; gt; gt; Sub Macro1()
| gt; gt; gt; Selection.NumberFormat = quot;yy-mm-ddquot;
| gt; gt; gt; With Selection.Font
| gt; gt; gt; .FontStyle = quot;Boldquot;
| gt; gt; gt; .Size = 12
| gt; gt; gt; End With
| gt; gt; gt; End Sub
| gt; gt; gt; --
| gt; gt; gt; Gary''s Student
| gt; gt; gt;
| gt; gt; gt;
| gt; gt; gt; quot;Louisequot; wrote:
| gt; gt; gt;
| gt; gt; gt; gt; Hi all
| gt; gt; gt; gt;
| gt; gt; gt; gt; When creating a custom number format, how would you ask it to show text in
| gt; gt; gt; gt; 'bold and size 12 font'?
| gt; gt; gt; gt;
| gt; gt; gt; gt; Thank you
| gt; gt; gt; gt;
| gt; gt; gt; gt; Louise
| gt;
| gt;
Thank you for replying.
The only reason I ask - I ran an Excel Advanced training course yesterday
and went through creating custom numbers, ie. changing the font colour, using
brackets for negative numbers etc. Because I showed them how to change the
font colour of positive and negative numbers, a delegate asked if it was
possible to change the size of the font too whilst we were there.

So it can't be done?

Thanks again.

Louise
quot;Niek Ottenquot; wrote:

gt; 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
gt; trying to achieve.
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;Louisequot; gt; wrote in message ...
gt; | Thank you for your reply.
gt; | Is it possible then to format the NUMBERS into size 12 font and bold?
gt; | Thanks again.
gt; | Louise
gt; |
gt; | quot; wrote:
gt; |
gt; | gt; correct I'm afraid - custom formats allow you to alter the formatting
gt; | gt; of the number (so you can include symbols, change decimals, format the
gt; | gt; date as month etc) but you cannot change the format of the cell (that
gt; | gt; would be custom cell format, not custom number format) and such an
gt; | gt; option does not exist
gt; | gt; Louise wrote:
gt; | gt; gt; So is this not possible to do via Format, Cells, Custom?
gt; | gt; gt; Thank you.
gt; | gt; gt; Louise
gt; | gt; gt;
gt; | gt; gt; quot;Gary''s Studentquot; wrote:
gt; | gt; gt;
gt; | gt; gt; gt; Hi Louise:
gt; | gt; gt; gt;
gt; | gt; gt; gt; NumberFormats and font characteristics are separate:
gt; | gt; gt; gt;
gt; | gt; gt; gt;
gt; | gt; gt; gt; Sub Macro1()
gt; | gt; gt; gt; Selection.NumberFormat = quot;yy-mm-ddquot;
gt; | gt; gt; gt; With Selection.Font
gt; | gt; gt; gt; .FontStyle = quot;Boldquot;
gt; | gt; gt; gt; .Size = 12
gt; | gt; gt; gt; End With
gt; | gt; gt; gt; End Sub
gt; | gt; gt; gt; --
gt; | gt; gt; gt; Gary''s Student
gt; | gt; gt; gt;
gt; | gt; gt; gt;
gt; | gt; gt; gt; quot;Louisequot; wrote:
gt; | gt; gt; gt;
gt; | gt; gt; gt; gt; Hi all
gt; | gt; gt; gt; gt;
gt; | gt; gt; gt; gt; When creating a custom number format, how would you ask it to show text in
gt; | gt; gt; gt; gt; 'bold and size 12 font'?
gt; | gt; gt; gt; gt;
gt; | gt; gt; gt; gt; Thank you
gt; | gt; gt; gt; gt;
gt; | gt; gt; gt; gt; Louise
gt; | gt;
gt; | gt;
gt;
gt;
gt;

lt;So it can't be done?gt;

No. You can change some characteristics (Font style, color, underline, strikethrough) using conditional formatting, but not the
font.

--
Kind regards,

Niek Otten

quot;Louisequot; gt; wrote in message ...
| Thank you for replying.
| The only reason I ask - I ran an Excel Advanced training course yesterday
| and went through creating custom numbers, ie. changing the font colour, using
| brackets for negative numbers etc. Because I showed them how to change the
| font colour of positive and negative numbers, a delegate asked if it was
| possible to change the size of the font too whilst we were there.
|
| So it can't be done?
|
| Thanks again.
|
| Louise
|
|
|
| quot;Niek Ottenquot; wrote:
|
| gt; 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
| gt; trying to achieve.
| gt;
| gt; --
| gt; Kind regards,
| gt;
| gt; Niek Otten
| gt;
| gt; quot;Louisequot; gt; wrote in message ...
| gt; | Thank you for your reply.
| gt; | Is it possible then to format the NUMBERS into size 12 font and bold?
| gt; | Thanks again.
| gt; | Louise
| gt; |
| gt; | quot; wrote:
| gt; |
| gt; | gt; correct I'm afraid - custom formats allow you to alter the formatting
| gt; | gt; of the number (so you can include symbols, change decimals, format the
| gt; | gt; date as month etc) but you cannot change the format of the cell (that
| gt; | gt; would be custom cell format, not custom number format) and such an
| gt; | gt; option does not exist
| gt; | gt; Louise wrote:
| gt; | gt; gt; So is this not possible to do via Format, Cells, Custom?
| gt; | gt; gt; Thank you.
| gt; | gt; gt; Louise
| gt; | gt; gt;
| gt; | gt; gt; quot;Gary''s Studentquot; wrote:
| gt; | gt; gt;
| gt; | gt; gt; gt; Hi Louise:
| gt; | gt; gt; gt;
| gt; | gt; gt; gt; NumberFormats and font characteristics are separate:
| gt; | gt; gt; gt;
| gt; | gt; gt; gt;
| gt; | gt; gt; gt; Sub Macro1()
| gt; | gt; gt; gt; Selection.NumberFormat = quot;yy-mm-ddquot;
| gt; | gt; gt; gt; With Selection.Font
| gt; | gt; gt; gt; .FontStyle = quot;Boldquot;
| gt; | gt; gt; gt; .Size = 12
| gt; | gt; gt; gt; End With
| gt; | gt; gt; gt; End Sub
| gt; | gt; gt; gt; --
| gt; | gt; gt; gt; Gary''s Student
| gt; | gt; gt; gt;
| gt; | gt; gt; gt;
| gt; | gt; gt; gt; quot;Louisequot; wrote:
| gt; | gt; gt; gt;
| gt; | gt; gt; gt; gt; Hi all
| gt; | gt; gt; gt; gt;
| gt; | gt; gt; gt; gt; When creating a custom number format, how would you ask it to show text in
| gt; | gt; gt; gt; gt; 'bold and size 12 font'?
| gt; | gt; gt; gt; gt;
| gt; | gt; gt; gt; gt; Thank you
| gt; | gt; gt; gt; gt;
| gt; | gt; gt; gt; gt; Louise
| gt; | gt;
| gt; | gt;
| gt;
| gt;
| gt;