Numbering formate

[Mike Busch]

I would like display baseball averages as three numbers
with out a peroid. I formated the number as special by
taking out the 0 from 0.386 to show .386, is there any way
to have a number less that 1 be displayed as a whole
number. Looking for 386. Thank you in advance.

 

[CLR]

Hi Mike.........

You can enter it as TEXT, by pre-formatting the cells as TEXT, or by typing
a leading apostrople before the 386,

Vaya con Dios,
Chuck, CABGx3

 

[unlikeKansas]

Mike,

If your first average is in A1, then entering the formula =INT(A1*1000) in a corresponding cell (e.g. B1) will acheive the result you want.