* instead of value

[Kash]

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

 

[Fred Smith]

Format it as Text.

Regards,
Fred.

 

[Jacob Skaria]

Kash

Right click>FormatCells>Custom>Type: "*" (in double quotes)

If this post helps click Yes

 

[Shane Devenshire]

Hi,

You can use "*" or shorter \* but this may not be acceptable since it will
cause cells containing negative numbers to return -* (minus astericks)

The following custom format might prove more to you needs:

\*;\*;\*