Hi
I have a column in a worksheet which has both currency & text

50.00
N.F.S.
90.00
90.00
N.F.S.
N.F.S.
60.00
60.00
50.00
N.F.S.
120.00

which I use as the data source to make labels in Word

The currency appears fine on the labels,
however, the text come out as 0 & I have to manually correct each one.

Can anyone tell me how to format this column please
--
Martin
©¿©¬