Spell Number formula not found in UDF

vipulgos

Active Member
Joined
Aug 17, 2002
Messages
335
Office Version
  1. 2010
Platform
  1. Windows
I've downloaded "Morefuntion", but in that there is no SpellNumber formula in UDF, can anyone guide me in this regard?
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
You mean morefunc? If so, the function is NUMTEXT.

Click on "=" on the Formula Bar and look in the dropdown list on the left side. Choose NUMTEXT from the Category Morefunc.
 
Upvote 0
On 2002-09-09 23:13, Aladin Akyurek wrote:

You mean morefunc? If so, the function is NUMTEXT.

Click on "=" on the Formula Bar and look in the dropdown list on the left side. Choose NUMTEXT from the Category Morefunc.
Is it possible to alter that numtext function, as in India, the currency mode is not like, Million, Trillion, but it is as "Lacs", "Crores", etc.
 
Upvote 0
On 2002-09-09 23:13, Aladin Akyurek wrote:

You mean morefunc? If so, the function is NUMTEXT.

Click on "=" on the Formula Bar and look in the dropdown list on the left side. Choose NUMTEXT from the Category Morefunc.
Is it possible to alter that numtext function, as in India, the currency mode is not like, Million, Trillion, but it is as "Lacs", "Crores", etc. Also if it is possible it should work in all work sheets. is it possible?
 
Upvote 0
On 2002-09-11 05:08, vipulgos wrote:
On 2002-09-09 23:13, Aladin Akyurek wrote:

You mean morefunc? If so, the function is NUMTEXT.

Click on "=" on the Formula Bar and look in the dropdown list on the left side. Choose NUMTEXT from the Category Morefunc.
Is it possible to alter that numtext function, as in India, the currency mode is not like, Million, Trillion, but it is as "Lacs", "Crores", etc. Also if it is possible it should work in all work sheets. is it possible?

You don't have access to the code underlying NUMTEXT, so it can be changed.

You could probably do so with the open code from Microsoft:

http://support.microsoft.com/support/kb/articles/Q140/7/04.ASP

http://support.microsoft.com/support/kb/articles/Q95/6/40.ASP
This message was edited by Aladin Akyurek on 2002-09-11 07:43
 
Upvote 0

Forum statistics

Threads
1,213,515
Messages
6,114,080
Members
448,548
Latest member
harryls

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top