Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MicroSoft Excel 2003 Formatting Numbers

Status
Not open for further replies.
hyde42

hyde42

Technical User
Sep 17, 2007
16
US
When I try to format social security numbers, the cells do not hold all nine digits. For example, if there are zeros in the first digits, the zeros are being dropped. I want the zeros to remain there...please help...
 
Sort by date Sort by votes
Click on the cell with the social security number

Click on Format/Cells/Number/Special/Social Security Number
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
Formatting Full Hard Drive 1
Replies
7
Views
292
austinpctech
austinpctech
Flinx
  • Locked
  • Question
unable to update microsoft edge 2
Replies
3
Views
1K
Rick998
Rick998
Keyboy
  • Locked
  • Question
Microsoft Cloud Storage Usage
Replies
0
Views
207
Keyboy
Keyboy
Flinx
  • Locked
  • Question
Windows 10 Strange problems recently appear caused by microsoft ransomeware protection
Replies
3
Views
381
Andrzejek
Andrzejek
iNotes4You
  • Locked
  • Question
Microsoft IExpress 'Extract-To'-Option
Replies
2
Views
423
iNotes4You
iNotes4You

Part and Inventory Search

Sponsor

Back
Top