And the OP said that excel is seeing the values as formulas. If Gina really
wanted to store the values as numbers, she'd have to remove the hyphens, too.

iliace wrote:

He said he wants them as numbers. So replace = with "", then set the
number format to "000-00-0000". It's under Format - Cells - Number -
Special.

On Oct 11, 4:50 pm, Dave Peterson wrote:
I think replacing it with nothing (leaving it blank) would be better than that
apostrophe. Those leading apostrophes can be difficult to remove--well, if they
have to be removed later.





Gary''s Student wrote:

Edit Find =
replace with '

Just replace the = sign with an apostrophe.
--
Gary''s Student - gsnu200749

"Gina K" wrote:

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.

--

Dave Peterson- Hide quoted text -

- Show quoted text -

--

Dave Peterson