View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
alan alan is offline
external usenet poster
 
Posts: 2
Default 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