How do I enter a decimal automatically without typing it every ti.

[Hayley]

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.

 

[Max]

There's an option you can set ..
Click Tools > Options > Edit tab
Check Fixed decimal > 2 places
Click OK

 

[Max]

Line should read as:

Check Fixed decimal > 2 places (say)

 

[Hayley]

Max, thank you. That is SO helpful. It will make life easier.
Hayley

 

[Max]

You're welcome, Hayley !
Glad to help