2007-01-31 18:19:07 · 11 answers · asked by ashish4477 1 in Computers & Internet ➔ Programming & Design
Does not seem possible
2007-01-31 18:25:08 · answer #1 · answered by Anonymous · 0⤊ 1⤋
U mean Spell a Number as 1=One, 2=Two lik that.
U need to Create a Function in Excel, and Use It.
For More Inforamtion i answered the same Question earlier also .
Check with it.
2007-01-31 23:47:05 · answer #2 · answered by Ravi Nanjunda Rao 3 · 0⤊ 0⤋
if you merely want to convert the format then use the method suggested by s anthony
however if you want to change the value as well, then use the following functions
text()
dollar()
roman()
depending on your need
text() will convert the number into any format you want like percentage, decimals, currency etc and as text
dollar will convert the number into currency. you can change the currency options in control panel regional settings
roman() will give you the number as a roman number again as text
you could also use bahttext() but you will get the text in thai language. to change that you will have to go to regional options again.
2007-01-31 19:21:59 · answer #3 · answered by vrkr74 2 · 0⤊ 0⤋
Use the TEXT function. For examples below, the value to be converted is in cell A5. Just substitute as you see fit.
To display value with 5 decimal place:
=TEXT (A5, "0.00000")
To display value as hours and minutes:
=TEXT (A5, "hh:mm")
To display value as GBP with comma at thousand:
=TEXT (A5, "0,000.00[$ GBP]")
To display as kilograms and a single decimal:
=TEXT (A5, "0.0[$ Kilograms]")
It really is that easy! Hope this helps you out. I use the Kilograms one all the time.
Kind Regards,
QwertyKPH @ Yahoo
2007-02-01 00:10:03 · answer #4 · answered by qwertykph 4 · 0⤊ 0⤋
Right-click the cell(s) and select "Format Cells" or simply hit CTRL+1. Go to the first tab (format) and select "Text" from the list. Click "OK," and you're done.
2007-01-31 18:21:54 · answer #5 · answered by Mickey Mouse Spears 7 · 0⤊ 0⤋
use fixed() function to convert number into text.
2007-01-31 21:47:55 · answer #6 · answered by Shahil 1 · 0⤊ 0⤋
Type in a single quote before the number...Dont close the quote..
Example : '4
Thats it...it will be stored as a text...
2007-01-31 18:30:39 · answer #7 · answered by Prem K 2 · 0⤊ 0⤋
just press: '
before you type the number
or change the format of the cell to text
2007-01-31 21:39:46 · answer #8 · answered by J 3 · 0⤊ 0⤋
go in formate cell & choose any option u want after u can get
ur right choise to do.
thats it.
2007-01-31 18:26:34 · answer #9 · answered by NILU 1 · 0⤊ 0⤋
bring a software analog into digital
2007-01-31 18:22:42 · answer #10 · answered by jaya prakash 2 · 0⤊ 0⤋
you couldn't...but if you are freak enough in excel...use lookup function approach...
2007-01-31 18:31:27 · answer #11 · answered by aRnObIe 4 · 0⤊ 0⤋