| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert phone to ***
Hi There,
I whold like to convert phone number(9886334401) to ********** only while i give print out in certain cells ( this is to hide the ph number) Manju |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Convert phone to ***
You could change the Cell Format to Custom and enter: **********
The cell contents will remain 9886334401 and will be visible in the Formula Bar when the cell is selected, but the display (and printout) will show **********. HTH, Elkar "manjunath" wrote: Hi There, I whold like to convert phone number(9886334401) to ********** only while i give print out in certain cells ( this is to hide the ph number) Manju |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Convert phone to ***
Thanks Very much Elkar........
"Elkar" wrote: You could change the Cell Format to Custom and enter: ********** The cell contents will remain 9886334401 and will be visible in the Formula Bar when the cell is selected, but the display (and printout) will show **********. HTH, Elkar "manjunath" wrote: Hi There, I whold like to convert phone number(9886334401) to ********** only while i give print out in certain cells ( this is to hide the ph number) Manju |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert phone numbers with dashes in them to just numbers | Excel Discussion (Misc queries) | |||
| Convert phone numbers with dashes in them to just numbers | Excel Discussion (Misc queries) | |||
| How to convert phone area-code to state name and time zone | Excel Discussion (Misc queries) | |||
| Date/ Phone log | Excel Discussion (Misc queries) | |||
| How can I cross reference phone numbers with existing phone numbe. | Excel Discussion (Misc queries) | |||
Linear Mode
