Home |
Search |
Today's Posts |
#1
|
|||
|
|||
text to number
Hi
i know there is a function to covert a number to text, si there a function to convert text to a number. D |
#2
|
|||
|
|||
text to number
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 |
#3
|
|||
|
|||
text to number
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 |
#4
|
|||
|
|||
text to number
Hi David,
If you mean like in check protection with wording like Fourteen Dollars and Ninety-Eight Cents see links at Numbers to words (as in check protection wording) (#numberstowords) http://www.mvps.org/dmcritchie/excel...numberstowords nothing to convert those words back to numbers. If you mean text that looks like numbers but is text and probably left aligned. Then you want to change the format to number or general and then you can run a macro like TrimALL which will reenter the values stripping any leading and trailing spaces after converting the nonbreaking space character Char(160) to spaces Char(20). To convert to text instead, format the cells as text then run the TrimALL macro. http://www.mvps.org/dmcritchie/excel/join.htm#trimall Instead of running a macro, if you don't have unprintable characters and don't want to run a macro -- though since you posted to programming would assume either solution is fine. You could copy an empty cell and add that to the column of cells via Ctrl+G (Edit, GoTo), then the Special Button, then add. To convert to text after formatting as text do the same add empty cell. Suggest you test on a copy of the worksheet as your data will be changed. If dates are involved you will certainly have to test what you are doing. If none of the above then you will certainly have to provide an example of what you are talking about. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "DMc2005" wrote in message ... Hi i know there is a function to covert a number to text, is there a function to convert text to a number. D |
#5
|
|||
|
|||
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 | |||
how to count the number of text frequencies and copy to other cell | Excel Worksheet Functions | |||
Change number in Text Box in Excel | Excel Discussion (Misc queries) | |||
edit number in cell without it changing to text | Excel Discussion (Misc queries) | |||
Format Number to Text | Excel Worksheet Functions | |||
16 digit number wont keep alteration unless format cell to text | Excel Discussion (Misc queries) |