Converting Numbers to words

F

Franklin

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Does anyone know how to convert numbers into word with applescript or whatever since excel doesn't support VB anymore?
 
F

Franklin

Does anyone know how to convert numbers into words with applescript or whatever since excel doesn't support VB anymore?
Sorry first time it said Word not Words
Example:$2,125.21
To: Two Thousand–One Hundred Twenty Five &21/100's
 
N

Niek Otten

Look at Hector Miguel's worksheet formula solution, that can be found here:

http://xldynamic.com/source/xld.xlFAQ0004.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


| Version: 2008
| Operating System: Mac OS X 10.5 (Leopard)
| Processor: Intel
|
| Does anyone know how to convert numbers into word with applescript or whatever since excel doesn't support VB anymore?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert numbers stored as text to numbers in excel 2008 3
How to stop Excel from rounding up 2
error with exel 1
Using formulas inside AppleScript 2
rows and columns in spreadsheet 1
cannot enter a long series of numbers without excel changing them. 3
I can't write numbers with the numbers pad 1
Averaging columns with missing numbers 3

Top