View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bindu Kalarikal Bindu Kalarikal is offline
external usenet poster
 
Posts: 1
Default How to convert Number into words in EXCEL same or a new cell ?

Thank You Norman,

I downloaded Laurent Longre's MoreFunc addin, and now iam able to convert
numeric value to text.

Hi Rao,

You can download Laurent Longre's MoreFunc addin and once it is installed
you will find a morefunction option when u r using Insert-function. Select
morefunc and use NBTEXT. It would convert exactly the way you mentioned below.

Regards,

Bindu.

"Rao AM" wrote:

.. like for a cell content of 3,456 I want this to appear in text as '
Three thousand four hundered fifty six'. Is it possible through some Format
cell command in same cell or by copy - paste special type into a new cell ?
Thnaks,
Rao AM