jonas

Select the column of data.

EditReplace

What: space

With: enter nothing here

Replace all.


Gord Dibben Excel MVP

On Wed, 16 Feb 2005 01:41:01 -0800, "jonas"
wrote:

I'm using an internal system in my company where I get the results in excel
using som sort of american excel standard. the numbers come out with a space
(1000 separator) between numbers (one million is spelled 1 000 000).

This is not the 1000 separator you can choose in FORMAT-CELL-NUMBER but some
other standard that I can't convert to normal numbers.

The format doesn't recognize 1 000 like the number 1000. If i try to sum 1
000 + 1 000 (i.e 2000) i get the result 0 (zero).

My problem is that I can't work in this format in my excel 2000 (english). I
need to be able to sort the numbers, use them in formulas etc.

How do i format the "unreadable" numbers into real numbers i can use.