Need No leading "0" and 3 decimal points?
You can change custom format to ".000"
"SRS" wrote:
Greetings:
I'm using Excel 2003.
For our baseball team I want to format a cell to calculate batting averages.
I want the calculated number to be a 3-digit number (such as .367) with NO
"0" before the decimal point...AND...if it calculates out to be something
like .400, I want it to read .400 instead of .4
I'm currently using the "custom" formatting of ".###" however, if like in
the example above the formula calculates out to end in a zero (such as .410)
it will show as .41 and not .410
I know this is probably simple and I'm over-looking something obvious, but I
can't figure it out.
Thank you!
|