#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default amount in words

hi,

I wanted to know how can one display the result of a calculation as a text
insteas of a number.
e.g 2+2= 4 - how does one get the output , 2+2=four

pls help,

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 709
Default amount in words

rohit, not directly but have a look here
http://www.xldynamic.com/source/xld.xlFAQ0004.html
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"rohit rajput" <rohit wrote in message
...
hi,

I wanted to know how can one display the result of a calculation as a text
insteas of a number.
e.g 2+2= 4 - how does one get the output , 2+2=four

pls help,



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
convert amount in words in excel AHTESHAM Excel Discussion (Misc queries) 1 January 5th 07 02:08 PM
how to convert the amount in currency into the amount in words? Ken Excel Discussion (Misc queries) 1 November 7th 06 09:16 AM
Cenvert dollar amount into words Edwin Excel Worksheet Functions 1 September 7th 05 03:35 AM
Converting amount in figures to amount in words Shrikant Excel Discussion (Misc queries) 1 August 16th 05 10:42 AM
Amount or Numbers in Words ron New Users to Excel 6 December 24th 04 07:32 PM


All times are GMT +1. The time now is 11:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"