Convert phone to ***

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking new phone to computer. 7
How do I set up a daily call out response response register? 1
News 419m phone numbers leaked in Facebook data breach 3
Formatting Phone Numbers in Excel 2007 Help 15
Buying a modern phone help needed. ;-) 14
How can we convert OST to PDF file format? 1
prints whole document, not the designated pages 3
Word Create a Phone Book using MailMerge in word 2007 0

Back
Top