| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
Threaded Mode
