0
How do you convert to number into word by using formula in excel especially in office 2003?
Wiki User
∙ 13y ago
To be able to do it for any number would be practically impossible. You could do it for a range of numbers or each individual digit, but when you start combining digits they make different kinds of numbers with different words, so it would become impossible. Even to do a small range of numbers can be a long process, though you could use a kind of lookup formula to do it. So it depends on the range of numbers that you want to be able to do it for.
To do it for the numbers from 0 to 20 you could do it as follows. In the cells from A1 to A21 you could put in the numbers from 0 to 20. Then in the cells from B1 to B21 you could put in the words from zero to twenty.
Then as a formula, say in cell D1, you could have the following:
=VLOOKUP(C1,A1:B21,2)
Then if you put any number from 1 to 20 in C1, it would show the word for that number in D1. To do it for more numbers you would have to put in the numbers and words you need in columns A and B and change the formula to cover the cells.
When you start getting to bigger numbers like 31245, it would obviously be too long to have the list of words to go that far. You could do each digit one by one, so for example the 4 would be forty and the 5 would be five and so on. However, your formula would be very complex and long, working out the position of each digit within a number so as to use the correct word, so it would be an impossible task. So there is no simple way of doing it beyond a reasonable range of values.
Wiki User
∙ 13y ago
Add your answer:
Earn +20 pts
What is cell in Microsoft office excel?
A cell is a rectangle that can hold a number, text, formula etc.
What is the excel formula to convert day 239 to display as August 27?
In Office 2007,...Select the cell(s) you want to format.Expand the Number section under the Home tab.Under the Number tab, choose Date from the list of Categories.From the Type list, select how you want the date presented.Click OK.
Help I am using open office for PC and you cant find any function that will search the spreadsheet for a a number you put into a cell Is there a function for that?
It will find a number - if the number is not a formula. For example - if you search for the number 30 it will find it - BUT - if the product in a cell is the result of a formula it will disregard it.
How do you convert pounds into Australian dollars from the post office?
go in and ask them to convert it....
Do you place a comma between the street name and apartment number?
The correct way is to separate an apartment or office number from a street address with a comma, especially if they both appear in the same line.
where is her office and phone number?
where is her office and phone number
Does the app store have Microsoft office?
No, you can get iWork instead which lets you convert things you create into Microsoft Office documents.
Where is the main office of Professional Skincare Formula Laboratory in the Philippines?
The main office for the Professional Skincare Formula labororatory is located in Quezon City, Philippines. They manufacture skin whitening products.
Can you convert text to a graphic format in windows office 2007?
In the office clipboard doesthemost recently copieditem appearat the bottom of thelist
How can you convert a ms office file 2010 to 2003?
Open the file in MS Office 2010 and save the file in compatibility mode.
What is the formula of ARR in front office?
formula for arr- total room revenue ARR= ------------------------------ total occupied room
What is the phone number for littlewoods head office?
what is the telephone number of littlewoods head office
