PDA

View Full Version : I need a excel formula


Nirmalhari
Feb 28, 2009, 03:04 AM
Hi

I need a excel formula for numbers ( Figures) are convert in words.

Like Rs.20 =Twenty only( In Formula) up to 15 digit.

Thanks
Regards
Hariom

darkvision
Mar 2, 2009, 06:02 PM
I'm not entirely sure what your asking for but excels help file has a full list of all formulas. Or are you saying you have the fomula but can't get it to do what you want?

DrJ
Mar 2, 2009, 06:06 PM
Numbers Spelled Out (Tips.Net) (http://excel.tips.net/Pages/T002270_Numbers_Spelled_Out.html)

There's a good macro that you can use. But you said "up to 15 digits?" How, exactly, do you mean that? You want to be able to spell out numbers like 220,468,070,135,486?