Hi

=TEXT(A1;"$#.00")
= "Annually, at the " & TEXT(L32;"$#.00") & " weekly figu"

Format affects only the cell, it is applied to. Really it affects how data
in formatted cell are displayed, not the data itself. I.e. when you format
the cell with number 2 as currency, it is displayed as $2.00, but really the
cell contains the number 2. Format ther same cell as date - and 2nd January
of 1900 is displayed, etc. When you reference the cell, then the source
format is not inherited.


Arvi Laanemets


"Bob Smith" wrote in message
hlink.net...

"Arvi Laanemets" wrote in message
...
Hi

= "Annually, at the " & L32 & " weekly figu"

Arvi Laanemets

Arvi - thanks for that timely reply. :) It works, however, on the
worksheet
the data shows up as a number instead of currency. IOW, in cell l32, it
had
a sum of $273.88.

The number listed in L38 shows up as 273.878476190476. Doesn't show up as
currency and takes up too much space in the cell.

I've tried to format L38 in different number formats - currency,
accounting,
special and it doesn't change the number.

Any additional suggestions?

Thanks,

Bob