Spell Number formula not found in UDF

vipulgos

Active Member
Joined
Aug 17, 2002
Messages
328
I've downloaded "Morefuntion", but in that there is no SpellNumber formula in UDF, can anyone guide me in this regard?
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,209
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.
 

vipulgos

Active Member
Joined
Aug 17, 2002
Messages
328
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.
 

vipulgos

Active Member
Joined
Aug 17, 2002
Messages
328
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?
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,209
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
 

Forum statistics

Threads
1,144,510
Messages
5,724,782
Members
422,578
Latest member
annsalinas

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
Top