Thank you so much for the insight....

but the whole column is miss formatted. I have tried add a coloumn to the
right of it, format that cell to "special then 0000000000), then custom paste
over the first column....no luck.....

anything else you can thin of?
--
k


"Danny C" wrote:

Although you may have done this, I still have to ask.
Did you pick the cell below it and using the right corner, drag it up on top
of the "bad cell". This should completely erase that cell and put in the
"new" cells formatting.



"Swoop" wrote:

I have an excel spreed sheet that comes in from a outside vendor that apears
to have some set fromatting within a specific cell that I can not correct for
my needs.
It is a numeric formatting (example; 0 2 10700 88807) When there is not a
number with a value higher then a zero in it's place the cell publishes its
value as (example;
0 2 3 42410).

What I would like to do is to format the column to be like this (34000
98777). So I need to replace the foregin value from space to numeric
value.....

any thoughts? Thanks in advance for your help

--
k