Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formatting text/number in a command
Hi, I have been working on a report and it requires capturing data fro another sheet... I used this command : +"The Profit for the year 2003 i :"&TEXT('Sheet2'!A2,"$#,##0.00);[red]($#,##0.00)") but the negative numbers are not displayed in red if I use this comman like Excel does if we format the negative numbers to display in re using the format cell/number option. Another problem is that I would like to display some words in Bold and/or underline/different colours/italics, like for example, in th above command , if I want to display "The Profit ......year 2003" i bold/undeline/italics/colour...what do i do??? PLEASE HELP !!!!! THANX IS DUE IN ADVANCE!!! ARVIN -- mnarvin ----------------------------------------------------------------------- mnarvind's Profile: http://www.excelforum.com/member.php...fo&userid=1520 View this thread: http://www.excelforum.com/showthread.php?threadid=26839 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with Formatting Number as Text | Excel Worksheet Functions | |||
Pivot Table Error Message - "Command Text not set for command obje | Excel Discussion (Misc queries) | |||
Formatting from Number to Text | Excel Discussion (Misc queries) | |||
Formatting Number as Text | Excel Programming | |||
Formatting Number as Text | Excel Programming |