I have been trying to figure out the formula to just simply place a number value in one cell and make it appear as text in another cell. How do I assign a value of a number to some text and then have it appear in another cell.
2006-12-20 14:08:52 · 3 answers · asked by Mr. Dangles 1 in Computers & Internet ➔ Programming & Design
Hi, you'll need to use a macro to do it.
try this link.
http://www.meadinkent.co.uk/xlnumberstext.htm
2006-12-20 15:28:32 · answer #1 · answered by madhavankkutty 3 · 0⤊ 0⤋
Your question is a big vague. Do you mean "1" being read as "one" -- or do you mean numeric vs. alphanumeric (like reading a social security number as text so you can include preceding "zeros")? The second situation should be easy: just format the cell for numbers for one cell and text for the other. If you're refering to a number = the word for the number, I couldn't help you with that one. Why not check Microsoft's website for possible solutions?
2006-12-20 14:21:05 · answer #2 · answered by George B 1 · 0⤊ 0⤋
Do you mean go from "1" to "one"? If so, I don't think you can do that with a normal formula (as far as I know, I may be wrong). You may have to use a macro or some sort of script that runs when the cell changes to do that.
2006-12-20 14:14:54 · answer #3 · answered by Bryan A 5 · 0⤊ 0⤋