Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default value shows in words

Ihave an excel sheet. and there is a column called A1= "Value" there I will
put the amount of an employee.... the next column called " Amount in words"
I need to get the value in words which I am putting on the "Value" column..
How can I get that problem solved.

Regards-
Mujeeb.

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

Hello,

I suggest to use my UDF spellnumber:
http://www.sulprobil.com/html/spellnumber.html

Regards,
Bernd
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 857
Default value shows in words

Hi,

You can get free code to convert numerical entries to text, such as 123 to
One Hundred Twenty Three, at the following web site:

http://support.microsoft.com/kb/213360


If this help, please click the Yes button.

Cheers,
Shane Devenshire

"Amount need to be shown in words" <Amount need to be shown in
wrote in message
...
Ihave an excel sheet. and there is a column called A1= "Value" there I
will
put the amount of an employee.... the next column called " Amount in
words"
I need to get the value in words which I am putting on the "Value"
column..
How can I get that problem solved.

Regards-
Mujeeb.

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
how to convert numeric to words Example 525 in words (Twenty five Ganta Amar Nath Excel Discussion (Misc queries) 2 July 17th 08 10:21 AM
Value shows but should not print uberathlete Excel Discussion (Misc queries) 3 October 31st 05 07:38 PM
Date shows as 01/01/00 Kmagg Excel Discussion (Misc queries) 2 September 23rd 05 11:51 PM
cell shows 20. Formula shows 20. why not 540/27 griswold Excel Worksheet Functions 2 August 12th 05 05:56 PM
how do i insert words into a column without erasing the words soccer5585 Excel Discussion (Misc queries) 0 June 8th 05 11:06 PM


All times are GMT +1. The time now is 04:21 PM.

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

About Us

"It's about Microsoft Excel"