Thread
:
How can I display a batting average as .333 rather than 0.333?
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
T. Valko
external usenet poster
Posts: 15,768
How can I display a batting average as .333 rather than 0.333?
Use a custom format of .000
Select the cells in question
Goto FormatCellsNumber tab
Select Custom
In the little box under Type: enter .000
OK out
--
Biff
Microsoft Excel MVP
"ernie d" <ernie
wrote in message
...
Reply With Quote
T. Valko
View Public Profile
Find all posts by T. Valko