View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
 
Posts: 2,202
Default Some of my SSN's are being treated as formulas

In addition to Gary's Student's post, you can use Find/Replace to remove the
minus signs too. Just put a minus sign in the Find field and leave the
Replace With field empty.

Rick


"Gina K" wrote in message
...
Hello,

I converted a spreadsheet from 123 to Excel and some of my SSN's are
evaluating as formulas. (When I look at the cell contents in the formula
bar, some cells have the equal sign preceeding the SSN.) Is there an easy
way to remove the equal sign?

Ideally, I want to store the numbers as 123456789, not 123-45-6789.

Thank you.