# I need a excel formula

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 Posts: 232, Reputation: 82 Full Member #2 Mar 2, 2009, 05: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?
Nirmalhari (Mar 3, 2009 03:45 AM): I want to spell numbers   Source:
 DrJ Posts: 1,344, Reputation: 1758 Ultra Member #3 Mar 2, 2009, 05:06 PM
Numbers Spelled Out (Tips.Net)

Theres 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?

## Check out some similar questions!

Excel formula [ 1 Answers ]

I have more questions about excel formula. In one column I have data appearing, as either a 1 or 2, at random as I input it. Each column has around 120 rows. In the row at the bottom I created a formula to calculate how often, on average, the data appears in that column. 1st how do I get each row...

Excel formula [ 3 Answers ]

I am using Excel 2007. I have 2 Sheets. In first sheet there are 3 coloumns, first one contains the employes number, second coloumn contains the name of employes and third one containes the department he works in. In the second sheet I have drop down list of the names of employes and the...

Excel Formula [ 1 Answers ]

Hi I have come across another problem with my spreadsheet. I have tried quite a few different ways to do it but can't get any of them to work. Within my spreadsheet I have a quote price and a forcasted date. However when a order is definitely received then a sale price and a new date is put into...

Excel formula IF function [ 2 Answers ]

Hi. I am creaing a spreadsheet for work. Basically I have a column that shows all the project names, it shows a date and a price for the project. I need this price to then be automatically placed into the appropriate monthly column. I.e if the project is 20,000 and happened on the 21st of jan...

Excel formula [ 3 Answers ]

I have a column that you manually enter a number; either 0 (zero) or any number greater than zero. I have another column with the formula of: =DAYS360(AN22,AQ22) If the resulting formula figure/number is greater than the manually entered number then I want a third column to equal: \$0.00 But...