| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Social Security Number formatting
I need to change the format to have the last 4 digits appear as xxxx. How do
I do this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Social Security Number formatting
You don't. Excel is not a secure program; even if you were to have Excel
show the last 4 digits as XXXX it would be a simple matter to circumvent that and display the whole SSN. Dave -- Brevity is the soul of wit. "Boo" wrote: I need to change the format to have the last 4 digits appear as xxxx. How do I do this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Social Security Number formatting
Perhaps if you were to elaborate as to your needs and intentions, someone
could offer some alternatives that might be acceptable. Vaya con Dios, Chuck, CABGx3 "Boo" wrote: I need to change the format to have the last 4 digits appear as xxxx. How do I do this? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Social Security Number formatting
The document is for internal use. I need to change the social from appearing
as 123-45-6789 to 123-45-xxxx. Any help would be appreciated. "Boo" wrote: I need to change the format to have the last 4 digits appear as xxxx. How do I do this? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Social Security Number formatting
With the SSN in A1, put this in B1 and copy down.......then HIDE column A
123-45-XXXX hth Vaya con Dios, Chuck, CABGx3 "Boo" wrote: The document is for internal use. I need to change the social from appearing as 123-45-6789 to 123-45-xxxx. Any help would be appreciated. "Boo" wrote: I need to change the format to have the last 4 digits appear as xxxx. How do I do this? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Social Security Number formatting
My apologies.........I posted the result rather than the formula.....use
this... =LEFT(A1,7)&"XXXX" hth Vaya con Dios, Chuck, CABGx3 "CLR" wrote: With the SSN in A1, put this in B1 and copy down.......then HIDE column A 123-45-XXXX hth Vaya con Dios, Chuck, CABGx3 "Boo" wrote: The document is for internal use. I need to change the social from appearing as 123-45-6789 to 123-45-xxxx. Any help would be appreciated. "Boo" wrote: I need to change the format to have the last 4 digits appear as xxxx. How do I do this? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Social Security Number formatting
Added twist. The formula works great BUT my cell I'm referencing was
originally set up as text. I convert the text to numbers and reformat to SSN. However, when I use the formula it does format it with last 4 digits appearing as XXXX but it does not put in the dashes. Additionally, I cannot reformat the cell with special formatting for SSN. The spreadsheet is given to me with the numbers showing as text and cannot be delivered to me in any other format. Any ideas on how to get the last 4 digits of a social security number to appear as xxxx, and formatted with dashes? "CLR" wrote: My apologies.........I posted the result rather than the formula.....use this... =LEFT(A1,7)&"XXXX" hth Vaya con Dios, Chuck, CABGx3 "CLR" wrote: With the SSN in A1, put this in B1 and copy down.......then HIDE column A 123-45-XXXX hth Vaya con Dios, Chuck, CABGx3 "Boo" wrote: The document is for internal use. I need to change the social from appearing as 123-45-6789 to 123-45-xxxx. Any help would be appreciated. "Boo" wrote: I need to change the format to have the last 4 digits appear as xxxx. How do I do this? |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Social Security Number formatting
Try this one.........
=LEFT(A1,3)&"-"&MID(A1,3,2)&"-"&"XXXX" Vaya con Dios, Chuck, CABGx3 "Boo" wrote: Added twist. The formula works great BUT my cell I'm referencing was originally set up as text. I convert the text to numbers and reformat to SSN. However, when I use the formula it does format it with last 4 digits appearing as XXXX but it does not put in the dashes. Additionally, I cannot reformat the cell with special formatting for SSN. The spreadsheet is given to me with the numbers showing as text and cannot be delivered to me in any other format. Any ideas on how to get the last 4 digits of a social security number to appear as xxxx, and formatted with dashes? "CLR" wrote: My apologies.........I posted the result rather than the formula.....use this... =LEFT(A1,7)&"XXXX" hth Vaya con Dios, Chuck, CABGx3 "CLR" wrote: With the SSN in A1, put this in B1 and copy down.......then HIDE column A 123-45-XXXX hth Vaya con Dios, Chuck, CABGx3 "Boo" wrote: The document is for internal use. I need to change the social from appearing as 123-45-6789 to 123-45-xxxx. Any help would be appreciated. "Boo" wrote: I need to change the format to have the last 4 digits appear as xxxx. How do I do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formatting cell number based on previous cell number | Excel Discussion (Misc queries) | |||
| formatting number value to text value in excel | Excel Worksheet Functions | |||
| How do I change a social security number to a number series? | Excel Discussion (Misc queries) | |||
| Conditional Number Formatting | Excel Discussion (Misc queries) | |||
| Conditional Number formatting? | Excel Discussion (Misc queries) | |||
Linear Mode
