Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Leading zero's missing for SSN numbers...
I get a file every month that contains 2500 social security numbers. The
dashes are in the right place but some of the leading zero's are always missing in that particular column. Instead of trying to add these manually, is there something I can do instead?? Thanks for any suggestions!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Leading zero's missing for SSN numbers...
Mickie,
You can format the column for Social Security numbers. Format - Cells - Number tab - Special, then select Social Security number. -- Earl Kiosterud www.smokeylake.com Note: Top-posting has been the norm here. Some folks prefer bottom-posting. But if you bottom-post to a reply that's already top-posted, the thread gets messy. When in Rome... ----------------------------------------------------------------------- "Mickie" wrote in message ... I get a file every month that contains 2500 social security numbers. The dashes are in the right place but some of the leading zero's are always missing in that particular column. Instead of trying to add these manually, is there something I can do instead?? Thanks for any suggestions!!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Leading zero's missing for SSN numbers...
Hi Earl,
Thanks so much for your quick reply, and I can't figure out if I'm top posting, or bottom posting....sorry if this is in the wrong place! I tried your fix numerous times prior to your return email, highlighting the column, and doing just what you mentioned...can't get it to change. I've also "unlocked" it on the advance tab (I think that's where it is). I've even tried doing Date and Text to Columns too.... I don't know what else to try and do??? When I get the file, as I mentioned, the dashes are already in the correct places, they do that for me before sending the file over...can you think of anything else??? Thanks so much! "Earl Kiosterud" wrote: Mickie, You can format the column for Social Security numbers. Format - Cells - Number tab - Special, then select Social Security number. -- Earl Kiosterud www.smokeylake.com Note: Top-posting has been the norm here. Some folks prefer bottom-posting. But if you bottom-post to a reply that's already top-posted, the thread gets messy. When in Rome... ----------------------------------------------------------------------- "Mickie" wrote in message ... I get a file every month that contains 2500 social security numbers. The dashes are in the right place but some of the leading zero's are always missing in that particular column. Instead of trying to add these manually, is there something I can do instead?? Thanks for any suggestions!!! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Leading zero's missing for SSN numbers...
Mickie,
Top posting is what you did. It's been the norm in these here parts forever. I don't care, but when someone posts a reply on top, then someone else posts a reply to that reply on the bottom, you have to jump all over the place and look at all the stuff, and pretty soon, you need a drink. What is this file you're getting. Is it already an Excel workbook. A text file? Say exactly what it is. If it's not a workbook (xls), then how are you getting it into a worksheet? If it's a text file (txt, csv, etc), then open it in Notepad and tell us what the social security numbers look like there. I suspect you have text, not numbers in the SSN column, and finding out why they're text will be way to the solution. -- Earl Kiosterud www.smokeylake.com Note: Top-posting has been the norm here. Some folks prefer bottom-posting. But if you bottom-post to a reply that's already top-posted, the thread gets messy. When in Rome... ----------------------------------------------------------------------- "Mickie" wrote in message ... Hi Earl, Thanks so much for your quick reply, and I can't figure out if I'm top posting, or bottom posting....sorry if this is in the wrong place! I tried your fix numerous times prior to your return email, highlighting the column, and doing just what you mentioned...can't get it to change. I've also "unlocked" it on the advance tab (I think that's where it is). I've even tried doing Date and Text to Columns too.... I don't know what else to try and do??? When I get the file, as I mentioned, the dashes are already in the correct places, they do that for me before sending the file over...can you think of anything else??? Thanks so much! "Earl Kiosterud" wrote: Mickie, You can format the column for Social Security numbers. Format - Cells - Number tab - Special, then select Social Security number. -- Earl Kiosterud www.smokeylake.com Note: Top-posting has been the norm here. Some folks prefer bottom-posting. But if you bottom-post to a reply that's already top-posted, the thread gets messy. When in Rome... ----------------------------------------------------------------------- "Mickie" wrote in message ... I get a file every month that contains 2500 social security numbers. The dashes are in the right place but some of the leading zero's are always missing in that particular column. Instead of trying to add these manually, is there something I can do instead?? Thanks for any suggestions!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Leading Zero's in Excel | Excel Discussion (Misc queries) | |||
How to add leading zero's | Excel Worksheet Functions | |||
How to get the leading zero's added in a document | Excel Worksheet Functions | |||
Leading zero's | Excel Discussion (Misc queries) | |||
Missing Zero's when copying from XLS to CSV | Excel Discussion (Misc queries) |