Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Text number to number value for calculating
How do you convert a text number format "51" to number 51 that I can use for calculations. Quotes used to illustrate that it is in text format. *Please email me at .* I am stumped. *Please Help!* Dave Diebold -- ddiebold7 ------------------------------------------------------------------------ ddiebold7's Profile: http://www.excelforum.com/member.php...o&userid=24237 View this thread: http://www.excelforum.com/showthread...hreadid=378475 |
#2
|
|||
|
|||
=INT("51") or if cell A1 contains "51", then =INT(A1) Mangesh -- mangesh_yadav ------------------------------------------------------------------------ mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470 View this thread: http://www.excelforum.com/showthread...hreadid=378475 |
#3
|
|||
|
|||
ddiebold7 Wrote: How do you convert a text number format "51" to number 51 that I can use for calculations. Quotes used to illustrate that it is in text format. *Please email me at .* I am stumped. *Please Help!* Dave Diebold Hiiii! It a very simple trick. Simply multiply the number (in text format ) by one (in the adjecent cell or column). -- sanskar_d ------------------------------------------------------------------------ sanskar_d's Profile: http://www.excelforum.com/member.php...o&userid=24217 View this thread: http://www.excelforum.com/showthread...hreadid=378475 |
#4
|
|||
|
|||
simce there are often spaces associated with Text numbers I often use
something like =value(trim(A1)) if the number is in Cell A1 "ddiebold7" wrote: How do you convert a text number format "51" to number 51 that I can use for calculations. Quotes used to illustrate that it is in text format. *Please email me at .* I am stumped. *Please Help!* Dave Diebold -- ddiebold7 ------------------------------------------------------------------------ ddiebold7's Profile: http://www.excelforum.com/member.php...o&userid=24237 View this thread: http://www.excelforum.com/showthread...hreadid=378475 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
making a number be text | Excel Worksheet Functions | |||
edit number in cell without it changing to text | Excel Discussion (Misc queries) | |||
Format Number to Text | Excel Worksheet Functions | |||
how to make number as text and left justified? | Excel Worksheet Functions | |||
EZ Q 4 U: How do I change a number to text, based on the number | Excel Worksheet Functions |