| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy figures to text
Hi there
I am wanting to produce a spreadsheet to merge into a program so I can print my cheques each month. I am trying to enter $150.00 in one cell, and would like the cell next to it automatically copy it as "One Hundred and Fifty Dollars". Does anyone know whether this is possible? Regards Sharon |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy figures to text
i
see: http://www.xldynamic.com/source/xld.xlFAQ0004.html -----Original Message----- Hi there I am wanting to produce a spreadsheet to merge into a program so I can print my cheques each month. I am trying to enter $150.00 in one cell, and would like the cell next to it automatically copy it as "One Hundred and Fifty Dollars". Does anyone know whether this is possible? Regards Sharon . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy figures to text
Hi Frank
Thank you, thank you thank you - works absolutely perfect!! Shaz L "Frank Kabel" wrote: i see: http://www.xldynamic.com/source/xld.xlFAQ0004.html -----Original Message----- Hi there I am wanting to produce a spreadsheet to merge into a program so I can print my cheques each month. I am trying to enter $150.00 in one cell, and would like the cell next to it automatically copy it as "One Hundred and Fifty Dollars". Does anyone know whether this is possible? Regards Sharon . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Figures and text combined | Excel Worksheet Functions | |||
| Separate figures from Text | Excel Discussion (Misc queries) | |||
| How to Convert Figures into Text in Excel | Excel Worksheet Functions | |||
| copy absolute figures and not formula | Excel Discussion (Misc queries) | |||
| How do I convert figures to text? | Excel Worksheet Functions | |||
Linear Mode
