Dave Peterson

Posts: n/a

Are they really numbers just formatted as SSN's?
=INT(A1/100000)

Or did you enter them as text?
123-45-6789
=substitute(left(a1,5),"-","")

DonJackson wrote:

Truncate column of social security numbers to the first four digits.

--

Dave Peterson

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sort by last 2 digits	mbparks	Excel Worksheet Functions	4	February 17th 05 06:11 PM
15 digits???	muckali	Excel Discussion (Misc queries)	1	February 15th 05 05:21 AM
Least number of digits in Y-axis labels	Charley Kyd	Charts and Charting in Excel	9	February 6th 05 03:03 PM
How do I format cells to a specific number of digits?	Gabriele	Excel Discussion (Misc queries)	3	February 5th 05 03:17 PM
Using a IF formula, I would like to drop the 2 digits in front of.	osuhoosier	Excel Discussion (Misc queries)	2	January 6th 05 08:21 PM

All times are GMT +1. The time now is 04:11 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us