M
mnarvind
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
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