| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
text to number
Perhaps this can be of help:
http://groups.google.com/group/micro...8b29cb1aecacf4 -- Gary''s Student "DMc2005" wrote: Sorry no good numbers are picked up from a string of text. D "Gary''s Student" wrote in message ... Say you have a column of numbers that are in text format. In an-unused cell put 1. Copy the cell and paste/special with multiply checked over the range of cells you want to convert. -- Gary's Student "DMc2005" wrote: Hi i know there is a function to covert a number to text, si there a function to convert text to a number. D |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to change scientific number to regular number or text | Excel Discussion (Misc queries) | |||
| Convert a number formatted as text to a number in a macro | Excel Programming | |||
| convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
| Why does this fail? =TEXT(RC3,Number)&" / "&TEXT(R32C,Number) | Excel Worksheet Functions | |||
| not able to convert text, or graphic number to regular number in e | Excel Worksheet Functions | |||
Hybrid Mode
