answersLogoWhite

0


Best Answer

It is not possible to type in words like "twenty" or "one million two hundred and eighty two thousand nine hundred and four" and get Excel to automatically convert any of them into their numeric equivalents. It could be done on a limited basis for a set range of numbers by using something like one of the lookup functions, but not for absolutely any number.

It is not possible to type in words like "twenty" or "one million two hundred and eighty two thousand nine hundred and four" and get Excel to automatically convert any of them into their numeric equivalents. It could be done on a limited basis for a set range of numbers by using something like one of the lookup functions, but not for absolutely any number.

It is not possible to type in words like "twenty" or "one million two hundred and eighty two thousand nine hundred and four" and get Excel to automatically convert any of them into their numeric equivalents. It could be done on a limited basis for a set range of numbers by using something like one of the lookup functions, but not for absolutely any number.

It is not possible to type in words like "twenty" or "one million two hundred and eighty two thousand nine hundred and four" and get Excel to automatically convert any of them into their numeric equivalents. It could be done on a limited basis for a set range of numbers by using something like one of the lookup functions, but not for absolutely any number.

It is not possible to type in words like "twenty" or "one million two hundred and eighty two thousand nine hundred and four" and get Excel to automatically convert any of them into their numeric equivalents. It could be done on a limited basis for a set range of numbers by using something like one of the lookup functions, but not for absolutely any number.

It is not possible to type in words like "twenty" or "one million two hundred and eighty two thousand nine hundred and four" and get Excel to automatically convert any of them into their numeric equivalents. It could be done on a limited basis for a set range of numbers by using something like one of the lookup functions, but not for absolutely any number.

It is not possible to type in words like "twenty" or "one million two hundred and eighty two thousand nine hundred and four" and get Excel to automatically convert any of them into their numeric equivalents. It could be done on a limited basis for a set range of numbers by using something like one of the lookup functions, but not for absolutely any number.

It is not possible to type in words like "twenty" or "one million two hundred and eighty two thousand nine hundred and four" and get Excel to automatically convert any of them into their numeric equivalents. It could be done on a limited basis for a set range of numbers by using something like one of the lookup functions, but not for absolutely any number.

It is not possible to type in words like "twenty" or "one million two hundred and eighty two thousand nine hundred and four" and get Excel to automatically convert any of them into their numeric equivalents. It could be done on a limited basis for a set range of numbers by using something like one of the lookup functions, but not for absolutely any number.

It is not possible to type in words like "twenty" or "one million two hundred and eighty two thousand nine hundred and four" and get Excel to automatically convert any of them into their numeric equivalents. It could be done on a limited basis for a set range of numbers by using something like one of the lookup functions, but not for absolutely any number.

It is not possible to type in words like "twenty" or "one million two hundred and eighty two thousand nine hundred and four" and get Excel to automatically convert any of them into their numeric equivalents. It could be done on a limited basis for a set range of numbers by using something like one of the lookup functions, but not for absolutely any number.

User Avatar

Wiki User

11y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

11y ago

It is not possible to type in words like "twenty" or "one million two hundred and eighty two thousand nine hundred and four" and get Excel to automatically convert any of them into their numeric equivalents. It could be done on a limited basis for a set range of numbers by using something like one of the lookup functions, but not for absolutely any number.

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How can I assign a numerical value to a text in Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What are numbers text datas or time of day that you type into a cell in Excel called?

Data or values.


How do you '0' can insert before a numerical number in Microsoft Excel?

type '05 instead of 05 the ' tells excel that you want to enter a text, not a number Proud to be of service HoloGuides.com


What is a text value also known as in Excel?

There is no single answer. Often it can be a label, which may be the answer you are looking for, but text values used in Excel are not always labels. If you have a list of names in a spreadsheet, the names are not labels. There may be a label at the top like "Names", but the names themselves are not labels.


Excel text By default?

By default, text in Excel is left aligned.


What is a text value in Excel?

Any regular text put into a cell is a text value. It can be use in formulas in many ways. There are a lot of functions that do things with text, like change the case of the text or search the text or find the length of the text etc. Values do not have to be only numbers. They can be other things, including text. If you type your name into a cell, then that is a text value.


What kind of cell has a numerical value of zero?

Apart from the number 0 and any function whose value is 0: eg cos(pi/2), a cell with text character, a false equation or, in some cases a blank have a numerical value of 0.


What is differentiate about word Excel and PowerPoint?

Powerpoint is presentation software for doing interactive presentations for showing to audiences. Excel is a spreadsheet application for numerical analysis and manipulation. Word is a word processor for working with text and creating documents to print.


What is the general form for the JavaScript statement used to assign a value to a text box object within a form?

document.formname.textfieldname.value = variable_or_literal


What type of data can be entered into a cell?

It is Label, Value, and Rule.There are lots of them:TextNumbersDatesTimesLogical


When would you use Excel instead of Word?

Excel is for numerical analysis and manipulation. Word is for working with text. There are few areas that both would do. You can create tables in Word and put numbers into them and even get them to do calculations, but nothing like what Excel can do. Excel can be used to create a simple grid, like a table in Word, but to put in a lot of additional text as part of an overall document then Word is better. If you are going to be doing lots of calculations, then use Excel. If you are doing lots of work with text in documents like a report, or a letter or a thesis, then Word is what you would use. You can get the two to work together, like bringing in calculations that have been completed in Excel as data for a report being done in Word.Excel is for numerical analysis and manipulation. Word is for working with text. There are few areas that both would do. You can create tables in Word and put numbers into them and even get them to do calculations, but nothing like what Excel can do. Excel can be used to create a simple grid, like a table in Word, but to put in a lot of additional text as part of an overall document then Word is better. If you are going to be doing lots of calculations, then use Excel. If you are doing lots of work with text in documents like a report, or a letter or a thesis, then Word is what you would use. You can get the two to work together, like bringing in calculations that have been completed in Excel as data for a report being done in Word.Excel is for numerical analysis and manipulation. Word is for working with text. There are few areas that both would do. You can create tables in Word and put numbers into them and even get them to do calculations, but nothing like what Excel can do. Excel can be used to create a simple grid, like a table in Word, but to put in a lot of additional text as part of an overall document then Word is better. If you are going to be doing lots of calculations, then use Excel. If you are doing lots of work with text in documents like a report, or a letter or a thesis, then Word is what you would use. You can get the two to work together, like bringing in calculations that have been completed in Excel as data for a report being done in Word.Excel is for numerical analysis and manipulation. Word is for working with text. There are few areas that both would do. You can create tables in Word and put numbers into them and even get them to do calculations, but nothing like what Excel can do. Excel can be used to create a simple grid, like a table in Word, but to put in a lot of additional text as part of an overall document then Word is better. If you are going to be doing lots of calculations, then use Excel. If you are doing lots of work with text in documents like a report, or a letter or a thesis, then Word is what you would use. You can get the two to work together, like bringing in calculations that have been completed in Excel as data for a report being done in Word.Excel is for numerical analysis and manipulation. Word is for working with text. There are few areas that both would do. You can create tables in Word and put numbers into them and even get them to do calculations, but nothing like what Excel can do. Excel can be used to create a simple grid, like a table in Word, but to put in a lot of additional text as part of an overall document then Word is better. If you are going to be doing lots of calculations, then use Excel. If you are doing lots of work with text in documents like a report, or a letter or a thesis, then Word is what you would use. You can get the two to work together, like bringing in calculations that have been completed in Excel as data for a report being done in Word.Excel is for numerical analysis and manipulation. Word is for working with text. There are few areas that both would do. You can create tables in Word and put numbers into them and even get them to do calculations, but nothing like what Excel can do. Excel can be used to create a simple grid, like a table in Word, but to put in a lot of additional text as part of an overall document then Word is better. If you are going to be doing lots of calculations, then use Excel. If you are doing lots of work with text in documents like a report, or a letter or a thesis, then Word is what you would use. You can get the two to work together, like bringing in calculations that have been completed in Excel as data for a report being done in Word.Excel is for numerical analysis and manipulation. Word is for working with text. There are few areas that both would do. You can create tables in Word and put numbers into them and even get them to do calculations, but nothing like what Excel can do. Excel can be used to create a simple grid, like a table in Word, but to put in a lot of additional text as part of an overall document then Word is better. If you are going to be doing lots of calculations, then use Excel. If you are doing lots of work with text in documents like a report, or a letter or a thesis, then Word is what you would use. You can get the two to work together, like bringing in calculations that have been completed in Excel as data for a report being done in Word.Excel is for numerical analysis and manipulation. Word is for working with text. There are few areas that both would do. You can create tables in Word and put numbers into them and even get them to do calculations, but nothing like what Excel can do. Excel can be used to create a simple grid, like a table in Word, but to put in a lot of additional text as part of an overall document then Word is better. If you are going to be doing lots of calculations, then use Excel. If you are doing lots of work with text in documents like a report, or a letter or a thesis, then Word is what you would use. You can get the two to work together, like bringing in calculations that have been completed in Excel as data for a report being done in Word.Excel is for numerical analysis and manipulation. Word is for working with text. There are few areas that both would do. You can create tables in Word and put numbers into them and even get them to do calculations, but nothing like what Excel can do. Excel can be used to create a simple grid, like a table in Word, but to put in a lot of additional text as part of an overall document then Word is better. If you are going to be doing lots of calculations, then use Excel. If you are doing lots of work with text in documents like a report, or a letter or a thesis, then Word is what you would use. You can get the two to work together, like bringing in calculations that have been completed in Excel as data for a report being done in Word.Excel is for numerical analysis and manipulation. Word is for working with text. There are few areas that both would do. You can create tables in Word and put numbers into them and even get them to do calculations, but nothing like what Excel can do. Excel can be used to create a simple grid, like a table in Word, but to put in a lot of additional text as part of an overall document then Word is better. If you are going to be doing lots of calculations, then use Excel. If you are doing lots of work with text in documents like a report, or a letter or a thesis, then Word is what you would use. You can get the two to work together, like bringing in calculations that have been completed in Excel as data for a report being done in Word.Excel is for numerical analysis and manipulation. Word is for working with text. There are few areas that both would do. You can create tables in Word and put numbers into them and even get them to do calculations, but nothing like what Excel can do. Excel can be used to create a simple grid, like a table in Word, but to put in a lot of additional text as part of an overall document then Word is better. If you are going to be doing lots of calculations, then use Excel. If you are doing lots of work with text in documents like a report, or a letter or a thesis, then Word is what you would use. You can get the two to work together, like bringing in calculations that have been completed in Excel as data for a report being done in Word.


What tag would you use to create a submit button with the label send form?

To create a submit button, use the input type submit. To assign text to the button, pass the text in as the value of the value attribute. Like so: <input type="submit" value="Send Form">


What is a feature of Excel that allows you to create curved or stylized text for a chart?

Excel does not create stylized text, but you can insert WordArt. You will find the WordArt option in Excel 2007 on the Insert tab in the Text section.