View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bj bj is offline
external usenet poster
 
Posts: 1,397
Default removing dashes from numbers

is the dash really there or is the dash added though formatting?
If they act like numbers when you add them, probably
<format<cell<number<general will get rid of them

"Pat Jones" wrote:

Hi;

I have a long column of numbers that contain "-" (I call them dashes). I
need to remove the dashes from these 3000+ numbers. Is there a way to
automate this process?

Thanks;

Pat