K
Kash
Hi, I need to display as * in the cell instead of value.. How to format that?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
smartin
Kash said:Hi, I need to display as * in the cell instead of value.. How to format that?
Try this in cell custom format:
"*";"*";"*";"*"
F
Fred Smith
Format it as Text.
Regards,
Fred.
Regards,
Fred.
J
Jacob Skaria
Kash
Right click>FormatCells>Custom>Type: "*" (in double quotes)
If this post helps click Yes
Right click>FormatCells>Custom>Type: "*" (in double quotes)
If this post helps click Yes
S
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:
\*;\*;\*
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:
\*;\*;\*