Dave,

I tried that, but it didn't work : the "space" is not a " " !

Robert

"Dave Peterson" a écrit dans le message de news:
...
I'd select the range to fix and use:
Edit|replace
what: (spacebar)
with: (leave blank)
replace all

Then format the range the way I like.

Robert wrote:

Hello,

I received a lot of currency data (in euros) but when numbers are greater
than 999, they have a space for the thousands, like ?1 250. So the
numbers
greater than 999 are understood by Excel as text. I can remove manually
this
space, but the columns are very long ;-(
Is it possible to remove this space with a VBA procedure which will run
all
along the selected column ?
Thanks for your help

--

Dave Peterson