Inline formatting!!!

Hi,

Suppose that I have the below formula:

=â??Total of: â?? & A1 & â??phone calls have been made.â??

Now suppose that I want to change the formatting of the value which is
returned by â??A1â??, i.e. the color and type. IS it possible? How?

Tnx,
Eqbal




--
Using Opera's revolutionary e-mail client: http://www.opera.com/m2/

David
Sat Nov 06 13:00:23 CST 2004

You can't change the color with the formula, but you can
change the formatting for number:
="Total of " & TEXT(A1,"#,##0") & " phone calls have been made."

You can format at total to dispaly the information so that you can still
treat the cell as a number Format, cells, custom format
"total of" #,##0 "phone calls have been made "

If you want to change the color of the entire cell use regular cell formatting
Format, cells, ... make changes to font and/or patterns...l
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Eqbal Vkilzadeh" <news@kala-ravan.com> wrote in message news:opsg12ndttw6rab0@eqbal...
> Hi,
>
> Suppose that I have the below formula:
>
> ="Total of: " & A1 & "phone calls have been made."
>
> Now suppose that I want to change the formatting of the value which is
> returned by "A1", i.e. the color and type. IS it possible? How?
>
> Tnx,
> Eqbal
>
>
>
>
> --
> Using Opera's revolutionary e-mail client: http://www.opera.com/m2/

Don
Sat Nov 06 13:02:23 CST 2004

& text(a1,"yourformathere")

--
Don Guillett
SalesAid Software
donaldb@281.com
"Eqbal Vkilzadeh" <news@kala-ravan.com> wrote in message
news:opsg12ndttw6rab0@eqbal...
> Hi,
>
> Suppose that I have the below formula:
>
> ="Total of: " & A1 & "phone calls have been made."
>
> Now suppose that I want to change the formatting of the value which is
> returned by "A1", i.e. the color and type. IS it possible? How?
>
> Tnx,
> Eqbal
>
>
>
>
> --
> Using Opera's revolutionary e-mail client: http://www.opera.com/m2/