I tried that, but it still keeps putting two zeros after the decimal. I went
into tools, edit, etc... and put in two fixed decimal places and 1523 came
out as 1523.00 I'm trying to get it so that if I type 1523 it will
automatically make it 15.23 but I can't seem to get it to work. Please help!

"bj" wrote:

check <tools<options<edit select fixed decimal places and say how many you
want
a 2 entered shows as 0.02 when two is selected
237 entered shows as 23.7 when 1 is selected

"chikalele" wrote:

I want to enter data into cells and not have to type the decimal point every
time. Is there any way to do this? I know you can set the number of places
behind the decimal point, but it still means you have to type the point every
time.