We’re rewarding the question askers & reputations are being recalculated! Read more.

Use for questions about Google Sheets cell format like formatting numbers, dates or using the equal, plus, minus symbols as part of texts (strings)

Google Sheets cell format is set by default to "Automatic". This could lead to problems like unwanted leading zero removal or dates not being recognized as that or text being treated as date when they aren't

Use together with

If your question is about conditional formatting use instead.

history | excerpt history