| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert numbers to text string
A1 has a 'General' Number format and it contains:
1062110181110621101811 What function should I use to convert the contents of A1 to a text string and what is the syntax? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert numbers to text string
I think you will find that your "number" is actually text, as there
are too many digits for Excel to recognise as a number. Anyway, you can do this in a helper cell: =A1&"" to convert it to text. Hope this helps. Pete On May 22, 12:32*am, GARY wrote: A1 has a 'General' Number format and it contains: 1062110181110621101811 What function should I use to convert the contents of A1 to a text string and what is the syntax? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert numbers to text string
Thanks, Pete.
Now, can you help with this too? COL A has 2,374 cells containing 9-character strings that look like this: 102050013 102050016 110103030 116300004 161180034 COL B contains 4,800 cells containing up to 27-characters strings that look like this: 102050001102050013 102050011102050016 106211018116040018116300004 110103012110103030 116040018116300004 161180032161180034 170212022170212025 174301015174301034174301040 174301017174301036174301041 174301034174301040 174301036174301041 174320014174320025 179221003179221008179221016 How do I search COL B for strings that match those in COL A? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert numbers to text string
Thanks, Pete.
Now, can you help with this too? COL A has 2,374 cells containing 9-character strings that look like this: 102050013 102050016 110103030 116300004 161180034 COL B contains 4,800 cells containing up to 27-characters strings that look like this: 102050001102050013 102050011102050016 106211018116040018116300004 110103012110103030 116040018116300004 161180032161180034 170212022170212025 174301015174301034174301040 174301017174301036174301041 174301034174301040 174301036174301041 174320014174320025 179221003179221008179221016 How do I search for strings in COL B that match strings in COL A? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert a text string to a number | Excel Discussion (Misc queries) | |||
| How do I convert a text string into a date? | Excel Worksheet Functions | |||
| Auto convert an alphanumeric string (CIS9638S) to numbers only? | Excel Worksheet Functions | |||
| Auto convert an alphanumeric string (CIS9638S) to numbers only? | Excel Worksheet Functions | |||
| Can i convert numbers into string format? | Excel Discussion (Misc queries) | |||
Linear Mode
