Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert Text To Number
I have about 15K id numbers I need to convert from text to number. All of the
id numbers end with _, for example, 106102_. I need to import these id numbers into Access but I can't convert them in Access and I can't figure out how to convert them in Excel so that I may import them. Can someone help? Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert Text To Number
Hi
If you have ID numbers in column A enter this formula in B1 and copy down. =(LEFT(A1,LEN(A1)-1))*1 Regards, Per "Antney" skrev i meddelelsen ... I have about 15K id numbers I need to convert from text to number. All of the id numbers end with _, for example, 106102_. I need to import these id numbers into Access but I can't convert them in Access and I can't figure out how to convert them in Excel so that I may import them. Can someone help? Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert Text To Number
Say your values are in column A. In B1 enter:
=--SUBSTITUTE(A1,"_","") and copy down Export the values in column B -- Gary''s Student - gsnu200794 "Antney" wrote: I have about 15K id numbers I need to convert from text to number. All of the id numbers end with _, for example, 106102_. I need to import these id numbers into Access but I can't convert them in Access and I can't figure out how to convert them in Excel so that I may import them. Can someone help? Thanks! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert Text To Number
Perfect! Thank you!!
"Per Jessen" wrote: Hi If you have ID numbers in column A enter this formula in B1 and copy down. =(LEFT(A1,LEN(A1)-1))*1 Regards, Per "Antney" skrev i meddelelsen ... I have about 15K id numbers I need to convert from text to number. All of the id numbers end with _, for example, 106102_. I need to import these id numbers into Access but I can't convert them in Access and I can't figure out how to convert them in Excel so that I may import them. Can someone help? Thanks! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert Text To Number
=LEFT(A1,LEN(A1)-1)*1
then copy down HIH |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert text to number | Excel Discussion (Misc queries) | |||
Convert text number to number formate | Excel Discussion (Misc queries) | |||
number convert to text | Excel Worksheet Functions | |||
convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
not able to convert text, or graphic number to regular number in e | Excel Worksheet Functions |