Convert phone to ***

M

manjunath

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
 
E

Elkar

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
 
M

manjunath

Thanks Very much Elkar........

Elkar said:
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
Click to expand...
 
Top