Excell format cells
 

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!

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!

Excell format cells
 

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.

"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!

Excell format cells
 

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??

"Gary''s Student" wrote:

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!

Excell format cells
 

I got it thanks... I replaced them with '
Thanks

"Gary''s Student" wrote:

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!

Excell format cells
 

I would enter -1 in an empty cell.

Copy that cell.

Select the 2000 numbers and EditPaste SpecialMultiply.

If that doesn't work, try EditReplace

What: -

With: nothing


Gord Dibben MS Excel MVP

On Wed, 7 May 2008 12:22:01 -0700, 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!