J Jacob Skaria Jun 28, 2009 #3 Kash Right click>FormatCells>Custom>Type: "*" (in double quotes) If this post helps click Yes
S Shane Devenshire Jun 28, 2009 #4 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: \*;\*;\*
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: \*;\*;\*
