When I put '4.8.8' into a cell in Google Sheets, it automatically converts it to '4.8.2008'. How do I avoid it?

migrated from superuser.com Feb 25 at 18:57

This question came from our site for computer enthusiasts and power users.


Did you try clicking on format options on the tool bar. Check the image the below where I have it highlighted. Highlight your cells,columsn,rows,etc. and make sure the format is set to number or automatic. Use the format you need.

enter image description here

  • you can always force it by adding ' in front of it like: '4.8.8

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy