Other ways of doing it are shown he
http://www.xldynamic.com/source/xld.xlFAQ0004.html
Hope this helps.
Pete
On Nov 28, 7:44 am, Bindu Kalarikal <Bindu
wrote:
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- Hide quoted text -
- Show quoted text -