Archive of Mr Excel Message Board
Back to Printing in Excel archive index
Back to archive home
Bold print
Posted by Garry on April 14, 2000 5:19 AM
I have the following in a worksheet
=" Please call me on "& " " & text(inputs!d45,"0000 0000")
Inputs!d45 is a phone number.
My question is how do I have the phone number in the format
0000 0000 to print in bold type
Thanks
Garry
Re: Bold print
Posted by Sherlock on April 18, 2000 6:22 AM
We assume that you need to change the format of selected cells, depending upon the value entered. To do so, please try out the following method:
1. Select the cells (for ex.a1 to a5).
2. Right click on selected cells.
3. Choose "Format cells".
4. Format cells dialog box will be displayed.
5. Select "Number" tab.
6. In "Number" tab select "Custom" in "Category" option.
7. Now, in "Type" option select "0000 0000".
8. Then in "Fonts" tab select "Bold" in "Font style".
9. Click OK.
Hope this works around your problem :-)
Regards,
sherlock.
holmes@qsupport.com
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.