Powered by IBForums
 Welcome Guest ( Log In | Register ) Search | Member List | Help

 
Formatting SSN, How to format U.S. Social Security Nos.
« Next Oldest | Next Newest » Track this topic | Email this topic | Print this topic
longshadows
Posted: Dec 1 2006, 05:41 PM


Newbie


Group: Free Support Members
Posts: 2
Member No.: 18629
Joined: 1-December 06



 Unlike Excle, StarCalc does not provide a preset format option for Social Security numbers. I've tried to use the normal User Defined options, but nothing works. To make things even stranger, here in New England, most SSN's have one or two leading "0".

Can anyone help?

Thanks,

Michael dry.gif
 
   Top
conficio
Posted: Jun 19 2007, 09:37 PM


Newbie


Group: Free Support Members
Posts: 3
Member No.: 18349
Joined: 2-November 06



 I guess you don't need the numeric value of the SSN. I'd format it as a string.


K<o>

--------------------
Plan-B for OpenOffice.org - Software support for the rest of us!
Blogging about StarOffice/OpenOffice.org and screencasting
 
    Top
JohnV
Posted: Jul 6 2007, 03:29 PM


Newbie


Group: Free Support Members
Posts: 3
Member No.: 17795
Joined: 28-April 06



 If in Calc you can use the following User Defined formats.
0##-##-####
or
000-00-0000
 
   Top
2 replies since Dec 1 2006, 05:41 PM Track this topic | Email this topic | Print this topic

Back to StarOffice™ Calc