Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
add Bold to the custom number format
Hello and thanks for the help. I am using the custom format to create a date
that looks like this: Thu - 3 Jan. I would like for ONLY the Thu portion to show up in bold format. Is that possible? I use both Excel 2003 and 2007. Thanks again, Sheri : ) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
add Bold to the custom number format
A result returned by a formula cannot be formatted in pieces. You can only
apply formatting to the entire cell, not pieces of the result. -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "SheriTingle" wrote in message ... Hello and thanks for the help. I am using the custom format to create a date that looks like this: Thu - 3 Jan. I would like for ONLY the Thu portion to show up in bold format. Is that possible? I use both Excel 2003 and 2007. Thanks again, Sheri : ) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
add Bold to the custom number format
hi,
it is possible to have multiple formats in a single cell but that applys to text only or numbers formated as text. formulas, dates and numbers cannot have multiple formats. reason - to have multiple formats reguires specific start and stop points within the cell. any cell that has data that varies will not meet this criteria. as to your situation, a date is seen by excel as a 5 digit number with decimals and is constantly changing. so no multiple formats possible. Sorry FSt1 "SheriTingle" wrote: Hello and thanks for the help. I am using the custom format to create a date that looks like this: Thu - 3 Jan. I would like for ONLY the Thu portion to show up in bold format. Is that possible? I use both Excel 2003 and 2007. Thanks again, Sheri : ) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving custom number format to NUMBER | Setting up and Configuration of Excel | |||
Bold certain items in custom number format | Excel Discussion (Misc queries) | |||
how do I add phone number format as a permanent custom format? | Excel Discussion (Misc queries) | |||
Format a cell with a custom number format | Excel Worksheet Functions | |||
Custom number format always defaults last number to 0. | Excel Discussion (Misc queries) |