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.
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.
Userlevel 7
+14
- Certified Zapier Expert
- 24279 replies
-
31 July 2023
Hi
Good question.
It’s likely due to the double periods.
- Beginner
- 7 replies
-
31 July 2023
Hi
Good question.
It’s likely due to the double periods.
Sorry, what do you mean?
Userlevel 7
+14
- Certified Zapier Expert
- 24279 replies
-
31 July 2023
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
- 7 replies
-
31 July 2023
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
Userlevel 7
+14
- Certified Zapier Expert
- 24279 replies
-
31 July 2023
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.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.