ExcelBanter - when displaying a batting average, how do I hide the 0 in 0.xxx?

ExcelBanter (https://www.excelbanter.com/)

- Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)

- - when displaying a batting average, how do I hide the 0 in 0.xxx? (https://www.excelbanter.com/setting-up-configuration-excel/173770-when-displaying-batting-average-how-do-i-hide-0-0-xxx.html)

ernie d[_2_]

when displaying a batting average, how do I hide the 0 in 0.xxx?

Dave Peterson

when displaying a batting average, how do I hide the 0 in 0.xxx?

Give the cell/range a custom format of .000

In xl2003
select the range
format|cells|number category
Custom
in the type
..000

And click ok.

ernie d wrote:

--

Dave Peterson

All times are GMT +1. The time now is 08:08 AM.