Right Click the cell > Format Cells > Customs Type ;;; there (thats 3 semicolons)
Click OK Now again open Format cells in the Protection Tab select "Hidden" checkbox Now when u click on ur cell the value is there but it will not show anything, neither in the formula bar (This requires worksheet to be protected) nor in the cell. Hope this helps. On Wed, Apr 27, 2011 at 9:09 PM, Rajesh K R <rajeshkainikk...@gmail.com>wrote: > Hi Experts, > > In my worksheet I used a cell to enter my secret password. I made the > file in way that the formulas in that sheet will work only if that > value is correct. I want hide the secret password from others. eg I > need the fonts like xxxx or ##### . How can I do it. > > Regards > > Rajesh kainikkara > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
