View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Excell format cells

Edit Replace
in the findwhat filed enter -
leave the replacewith field alone
then
replace all
--
Gary''s Student - gsnu200784


"ft" wrote:

I have a column on a excel spredsheet that has about 2000 rows.
All the numbers have a dash at the begging of the numbers.
How do I get rid of those dashes without doing it one by one?
Thank you!