View Single Post
  #3   Report Post  
Bob Smith
 
Posts: n/a
Default


"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