Excell format cells

  • Thread starter Thread starter ft
  • Start date Start date
F

ft

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!
 
Edit > Replace
in the findwhat filed enter -
leave the replacewith field alone
then
replace all
 
Hi,
Select the first cell in the column
Then Edit Menu, Replace
In the Find What field put -
Leave the Replace With field blank.
Search by Columns.
Click Replace All.
Regards - Dave.
 
Gary,
Thanks,
One more question... I had some numbers with leading zeros and those zero
are gone... how can i do this witout loosing the leading zeros??
 
I got it thanks... I replaced them with '
Thanks

Gary''s Student said:
Edit > Replace
in the findwhat filed enter -
leave the replacewith field alone
then
replace all
Click to expand...
 
I would enter -1 in an empty cell.

Copy that cell.

Select the 2000 numbers and Edit>Paste Special>Multiply.

If that doesn't work, try Edit>Replace

What: -

With: nothing


Gord Dibben MS Excel MVP
 
Back
Top