Numbers to Text

[davewattuk]

Got very basic knowledge of excel and was hoping for a bit of help.

If i have a figure in one cell, can I, in the next cell, make this show as text?

I.E. 123.45 One Hundred and twenty three point four five

Any help would be much appreciated.

Thanks

 

[grd]

Yes, but it is very long winded - at least my method is!

PM me with your e-mail address and I can send you an example.

Graham

 

[Dsuperc]

Under recommended Add in and Links, there is a ASAP utility, download this and there is a tool in there that would help you.