tricky

[dido22]

Hello,

This is (I think) a tricky problem.

In column A I have a list of integers in ascending order, i.e. 1,2
,3,4,5...........27,28,29,30

In the next few columns I want to spell out the numbers, so if '1' is in A1,
I want O,N,E in columns B1,C1,D1.

A17 is '17' , so I want S,E,V,E,N,T,E,E,N in columns B17, C17, ....J17

I cannot see a way of generating the data automatically. I think I have to
type it all in by hand ??

Any Ideas?

Thanks as always

KK

 

[Cimjet]

Hi
There's no direct functions to do this.Check out
the links below.

http://www.ozgrid.com/VBA/ValueToWords.htm
http://support.microsoft.com/kb/213360
http://www.xldynamic.com/source/xld.xlFAQ0004.html

HTH
John