Why when I update a cell value with a formatter output some values remain as text and others as number?
I need them all to remain as text so that the leading zeros are not removed.
Question
How do I keep leading zeros when updating cell values with formatter output in Google Sheets?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Orchestrator & Solution Partner
Hi
Good question.
It’s likely due to the double periods.
- Beginner
Hi
Good question.
It’s likely due to the double periods.
Sorry, what do you mean?
+14- Zapier Orchestrator & Solution Partner
GSearch returned these results to try:
Number Formatting Error in Google Sheets [Comma – Dot Error]
- Go To Google Sheets.
- Click on File > Settings.
- Select Locale.
- Click save & reload.
- Beginner
Thank you
But now I have a similar problem with the dates: some appear as number and some as date. Could you help me please? How to fix filling to automatically work as date value
+14- Zapier Orchestrator & Solution Partner
GSearch returned these results.
https://www.google.com/search?q=google+sheets+date+format
To apply a custom date or time format to your spreadsheet:
- On your computer, open a spreadsheet in Google Sheets.
- Highlight the data you want to format.
- Click Format. Number.
- Click Custom date and time.
- Search in the menu text box to select a format. ...
- Click Apply.
Early access
Next Gen Zaps
Build and deploy automations from AI tools you already use. With Agentic Management, if anything breaks, the agent diagnoses the issue and proposes a fix.
Request access now
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.