Spell Number formula not found in UDF

vipulgos

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

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,210
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
331
Office Version
  1. 2010
Platform
  1. Windows
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
331
Office Version
  1. 2010
Platform
  1. Windows
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,210
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,181,686
Messages
5,931,419
Members
436,788
Latest member
Oteez

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