| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
single quote 10-digit number that has leading zeroes & then conca.
trying to put a 'list' of 10-digit numbers into EXCEL--the numbers have at
least 1 leading zero & # must be in single quotes. Then I want to concatenate this '10-digit' number with a text phrase before & after number -- then autofill with the down the list of numbers keeping the quoted leading zeroes. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel - numbers as text | New Users to Excel | |||
| CSV leading zeroes | Excel Discussion (Misc queries) | |||
| How do I format data cells in Excel to keep leading zeroes? | Setting up and Configuration of Excel | |||
| When we enter a 16 digit number (credit card) the last digit chan. | Excel Discussion (Misc queries) | |||
Threaded Mode
