ExcelBanter

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Why? (https://www.excelbanter.com/excel-worksheet-functions/78574-why.html)

Anoli

Why?

I try to enter info in a cell - type 0.77 and it changes to 1. How do I
change it back?

Beege

Why?

Anoli

Look at Tools/Options/Edit
Make sure "fixed decimal places" is not checked
Also, check the cell format, may be Number/No decimal places or Custom/ 0

Beege

"Anoli" wrote in message
...
I try to enter info in a cell - type 0.77 and it changes to 1. How do I
change it back?

Trevor Shuttleworth

Why?

You could try increasing the number of decimal places displayed.

Click on the Increase Decimal icon on the Formatting Menu bar a couple of
times.

Note: a more specific description of your problem would get more people to
look and maybe respond.

Regards

Trevor

"Anoli" wrote in message
...
I try to enter info in a cell - type 0.77 and it changes to 1. How do I
change it back?

Richard O. Neville

Why?

Reformat the cell to format 0.00.

"Anoli" wrote in message
...
I try to enter info in a cell - type 0.77 and it changes to 1. How do I
change it back?

All times are GMT +1. The time now is 11:14 PM.