Posted to microsoft.public.excel.misc

MelissaC

external usenet poster

Posts: 1

social security numbers in Excel

I have an excel spreadsheet that currently displays social security numbers
in this format. 000-00-0000. Is there a way to change that format so only
the last five digits display? example ***-*0-0000

Thank you.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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
FedEx tracking numbers in Excel	Adam J	Excel Discussion (Misc queries)	0	July 24th 06 07:34 PM
Converting numbers stored as dates to text in Excel	David from Furdale	Excel Discussion (Misc queries)	1	July 17th 06 06:34 PM
How do I sort Library of Congress call numbers in Excel?	Casper	Excel Worksheet Functions	7	July 12th 06 06:46 PM
excel viewer	littlebird0770	Setting up and Configuration of Excel	6	July 6th 06 04:10 PM
How to convert Excel imported numbers from text to numbers?	Alden	Excel Discussion (Misc queries)	9	April 1st 05 09:51 PM

All times are GMT +1. The time now is 12:24 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us