ConvertTextToNumbers
I have a column with numbers in them with a leading blank, like below.
'5179455010055341
I want to copy them to another column and have them formatted like below:
5179 4550 1005 5341
I was using Data TextToColumns with a space and ' for delimiters, but I
end up with the last digit of each number being 0, like below.
5179 4550 1005 5340
I am using #### #### #### #### for the formatting and Excel 97. How can
I get the values copied and formatted correctly, without altering the
digits?
TIA
|