View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
smartin smartin is offline
external usenet poster
 
Posts: 915
Default * instead of value

Kash wrote:
Hi, I need to display as * in the cell instead of value.. How to format that?


Try this in cell custom format:

"*";"*";"*";"*"