Importing French Numbers

[Mike]

Hello all,

I've got a document that contains the French format for
numbers. For Example, the number 16543 shows up as 16
543, with a hard space between group of three numbers.
As it stands now, Excel does not recognize 16 543 as a
number and will not run any calculations or formulas. Is
there any way to format these numbers en mass? I can't
think of the VB code that would remove all spaces from a
specified range...

Any help would be greatly appreciated,

Thanks in advance,


Mike

 

[Andy B]

Mike

Use a helper column. In the column alongside your data use:
=SUBSTITUTE(A2," ","")
Select the column and use Edit/Paste Special Values, to replace the formula
with the actual values.
Then copy a blank cell, select this column and use Edit/Paste Special/Add.
This makes the cells numeric.

Andy.

 

[Andy B]

Well, OK, that is a little bit easier than my suggestion!!

Andy.