View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default 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!