Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format block of cells to not show entire SSN?
I've tried custom formatting, but nothing changes....please help!
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format block of cells to not show entire SSN?
Well, we could each *guess* at what conditional formatting conditions you
tried, but it might be more efficient if you were to tell us. -- David Biddulph Kelley wrote: I've tried custom formatting, but nothing changes....please help! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format block of cells to not show entire SSN?
Hi,
What do they look like now and what do you want them to look like. Is the only thing in the cell the SSN? You can hide any entry in a cell by using the custom format ;;; (three semi-colons) -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Kelley" wrote: I've tried custom formatting, but nothing changes....please help! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format block of cells to not show entire SSN?
There's no formatting (numberformatting) that will hide parts of the SSN.
You could treat it as text (preformat the cell as text or start with a leading apostrophe) and make parts white on white (say) and the value would be visible in the formula bar, but look as a partial SSN in the cell. Or you could use a different cell to extract the portion that you want (maybe =mid()). But... If you're sharing this with others who should not see the SSN's, don't do this. You could hide the cell with the actual SSN and protect the sheet, but worksheet protection is very easily broken--or someone could just write a formula to see the value in that hidden cell. It would be better to just enter the portion of the SSN that can be shared with others. Kelley wrote: I've tried custom formatting, but nothing changes....please help! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
linked workbook (cells) does not show entire length of original te | Excel Worksheet Functions | |||
Excel 2002: Can I condition format block of cells ? | Excel Discussion (Misc queries) | |||
How do I format cells to show date in Australian not US format? | Excel Worksheet Functions | |||
show a block of info from a list on another worksheet | Excel Worksheet Functions | |||
Conditional Format to change entire row based on one cells data | Excel Discussion (Misc queries) |