Spell Number

[mrcdqtt]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) I have a check register spreadsheet I created in Windows version of Excel that can print checks. It includes a VB function that takes the numeric dollar value (e.g. $100.25) and spells out that number on the check (e.g. One Hundred Dollars and Twenty Five Cents). How can I do this on my Mac?

 

[John McGhie]

The UK Firm PA Tools provides a shareware solution that you can try before
you buy:

http://www.patools.co.uk/excel/freebies/index.html

That's the only way to do this in Excel 2008. All the other solutions
(including the Microsoft one) require VBA.

Cheers

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) I have a check
register spreadsheet I created in Windows version of Excel that can print
checks. It includes a VB function that takes the numeric dollar value (e.g.
$100.25) and spells out that number on the check (e.g. One Hundred Dollars and
Twenty Five Cents). How can I do this on my Mac?

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:[email protected]

 

[Bob Greenblatt]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) I have a
check register spreadsheet I created in Windows version of Excel that
can print checks. It includes a VB function that takes the numeric
dollar value (e.g. $100.25) and spells out that number on the check
(e.g. One Hundred Dollars and Twenty Five Cents). How can I do this on
my Mac?

The short answer is you can't! that function requires VBA which is not
available. you can downgrade to Excel 2004, Buy Parallels, a copy of
Windows, and a copy of Windows office to run the application on your Mac
in Windows; or wait til the next version of Office apears.