View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Swoop Swoop is offline
external usenet poster
 
Posts: 3
Default Cell that will not format

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