I have a column comprised exclusively of numbers. Whenever I add 050, the sheet automatically changes it to 50. I have tried prepending a space, but it makes no difference.
What can I do to avoid this?
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.Sign up to join this community
Since @jam 's answer there might be some improvement in Spreadsheet's features.
If you'd like to preserve and use the numbers as figures (e.g., automatic fill) you might apply the settings from the
Format > Number > More Formats > Custom number format...
menu, and set the pattern to
000, where the number of zeros represent the number of digits to which the completion will be made with the leading zeros.
You can format the contents of the cell as
Plain Text. Here are step-by-step instructions of how to format a number in a Google Sheet.