Quote:
Originally Posted by Bill Douglas
Thanks, but if I go Format, Cells, Number, and set it to 0 decimal places the number 45 displays as 0.
Format, Cells, General displays it as .45
|
Not sure what version of excell you are using.
Go to Preferences, look for Edit, Uncheck or set to 0, "Display this number of decimal places" option.