Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
custom number formats
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
custom number formats
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
custom number formats
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
custom number formats
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
custom number formats
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
custom number formats
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 | | |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
custom number formats
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 "Niek Otten" wrote: 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 | | |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
custom number formats
<So it can't be done?
No. You can change some characteristics (Font style, color, underline, strikethrough) using conditional formatting, but not the font. -- Kind regards, Niek Otten "Louise" 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 | | | | "Niek Otten" wrote: | | 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 | | | | | | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format a cell with a custom number format | Excel Worksheet Functions | |||
Newbie Help for Custom Number Formats | New Users to Excel | |||
Auto Formatting Custom Number | Excel Discussion (Misc queries) | |||
Custom Number format question | Excel Discussion (Misc queries) | |||
Custom Formats | Excel Discussion (Misc queries) |