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

Format it as Text.

Regards,
Fred.

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

Kash

Right clickFormatCellsCustomType: "*" (in double quotes)

If this post helps click Yes
---------------
Jacob Skaria


"Kash" wrote:

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

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:

\*;\*;\*

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Kash" wrote:

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

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

Try this in cell custom format:

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