Numbers – how do I start a list of numbers all starting with 00?

Tagged: Google Sheets, Number Format, Plain Text

This topic has 1 reply, 2 voices, and was last updated 7 years, 3 months ago by Rob Clarke.

Viewing 1 reply thread

Author

Posts
- August 24, 2017 at 2:39 pm #2736
  Niva Tafili
  Participant
  
  Points: 24
  How do I start a list of numbers all starting with 00?
  
  I tried going into ‘Custom Number Format’… but I think I’m missing a step.
  - This topic was modified 7 years, 2 months ago by Rob Clarke.
- August 25, 2017 at 6:28 pm #2738
  
  Rob Clarke
  Keymaster
  
  Kia ora Niva,
  
  Good question, this can be annoying! The solution is to set the format of the data to ‘Plain Text’ which will give you what you want – you were so close!
  
  Let me know how you go and have a lovely weekend,
  
  Rob
Author

Posts

Viewing 1 reply thread

You must be logged in to reply to this topic.