Changing numbers to words

[SaTaNHeaD2003]

Im new here and new to excel.I have a question regarding changing numbers to words.e.g

1535.25 will be written as One thousand Five Hundred thirty five and twenty five cents.
Can it be done?

1 more, How do i LOCK a single cell from being audited?

thanx for any help.Sorry for bad english.I'M not an Englishmen!!!LOL

 

[Tazguy37]

Yes, it can be done. Have a look here to see how: http://www.ozgrid.com/VBA/ValueToWords.htm

 

[Yogi Anand]

Im new here and new to excel.I have a question regarding changing numbers to words.e.g

1535.25 will be written as One thousand Five Hundred thirty five and twenty five cents.
Can it be done?

1 more, How do i LOCK a single cell from being audited?

thanx for any help.Sorry for bad english.I'M not an Englishmen!!!LOL

Hi SaTaNHeaD2003:

Welcome to MrExcel Board!

For the first one if you can use NumText function from the MoreFunc Add-in -- see the following ...

Book1
	A	B	C	D
2		1535.25	onethousandfivehundredthirty-fivedollarstwenty-fivecents
Sheet5

And for the second question I am not sure I have understood your requirement -- hoever look into FORMAT|Cells|Protection|Locked on a Protected worksheet!

 

[SaTaNHeaD2003]

thanx for the help.it works really great.Just one more question,i used 2 cells to seperate dollar and cents.

e.g A1=128 A2=58

How do make it to spell : One Hundred Twenty Eight and Fifty Eight Cent

can it be done? I used no decimal.

About the protect thing, it doesnt work.It protect entire sheet!!I'm using Office XP right now.

 

[Yogi Anand]

thanx for the help.it works really great.Just one more question,i used 2 cells to seperate dollar and cents.

e.g A1=128 A2=58

How do make it to spell : One Hundred Twenty Eight and Fifty Eight Cent

can it be done? I used no decimal.

About the protect thing, it doesnt work.It protect entire sheet!!I'm using Office XP right now.

How about ...

y040630h1.xls
	A	B	C	D
1	128
2	58		OneHundredTwenty-EightFifty-EightCent
3
Sheet5

formula in cell C2 is ...
=PROPER(SUBSTITUTE(SUBSTITUTE(NUMTEXT(A1+A2/100,1),"dollars",""),"cents","cent"))

Would this do?

 

[SaTaNHeaD2003]

I believe MS Excel XP has no function NUMTEXT.

 

[SIXTH SENSE]

I believe MS Excel XP has no function NUMTEXT.

you should have the Morefunc add in. its not native to xcel.

Download it here.
http://longre.free.fr/english/

 

[SaTaNHeaD2003]

I inserted the MoreFunc add-ins, but still no NUMTEXT.Anyone?

 

[2rrs]

ASAP Utilities also has this capability and many other features,

Found here:
http://www.asap-utilities.com/

 

[Yogi Anand]

I inserted the MoreFunc add-ins, but still no NUMTEXT.Anyone?

I also do not see NumText listed as one of the available functions in my MoreFunc Add-in in my EXCEL 97, but I can use the function as you have seen in the illustration in my earlier posts in this thread -- so go ahead and try using the function even though it is not listed -- and tell us if it works for you.