| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column with currency & text - how to format?
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 ©¿©¬ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to format cells in Excel 2007 (i.e. currency format)? | Excel Discussion (Misc queries) | |||
| Changing cell format from text to currency | Excel Worksheet Functions | |||
| Currency format in visual basic text box | Excel Discussion (Misc queries) | |||
| Change General Format to Currency Format | Excel Worksheet Functions | |||
| Changing format of column from "general" to "currency" | Excel Discussion (Misc queries) | |||
Threaded Mode
