ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Copy figures to text (https://www.excelbanter.com/excel-programming/309849-copy-figures-text.html)

Shaz L

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

Frank Kabel

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
.


Shaz L[_2_]

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
.




All times are GMT +1. The time now is 12:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com