I’m creating an excel document that goes from excel to zapier to plumsail and then creates an excel.
Everything looks great but the resulting numerical output gets tagged with a warning in excel that says “ Number Stored as Text” in Excel.
This seems like it’s breaking some the excel functionality since the notebar doesn’t show the sum.
The original file is excel and is set to numbers.
I haven’t been able to track down what’s causing this output issue.
Hello @antonio.bowens ,
Thank you for the details.
I reviewed the resulting file, and I can see that the numeric values are written in a format like 1,055,189 (with comma thousands separators). In Excel, this format can be interpreted as text depending on the workbook’s regional settings and the number format expected (for example, when a comma is used as a decimal separator in some locales). That is why you see the warning “Number Stored as Text”, even though the cell format is set to Number.
Could you please check and share:
Your Excel locale/region settings (or the expected number format)
How the numbers look in the original Excel file (a screenshot or a small sample file is enough)
Once I have this, I can suggest the best way to generate true numeric values.
Best regards,
Aleksandra
Plumsail team
Hi @antonio.bowens ,
Thank you for the information.
Could you please confirm which exact Plumsail Documents action you’re using in Zapier?
For example, if you use Generate Document From XLSX Template in Zapier, you сan select Locale to match your regional format. If the Locale is set correctly, the output should align with your Excel regional settings.
If the Locale is set correctly and the issue still occurs, could you please share:
You can send the files to support@plumsail.com and reference this conversation so we can investigate the issue for you.
Best regards,
Aleksandra
Plumsail team
My set up is looking for any new rows in a shared doc.
Then using start process and it uses the template I’ve uploaded into plumsail.
If there is a better setup than this , please let me know.
Hello @antonio.bowens ,
There are two possible approaches to filling an Excel file while tracking new rows in Zapier:
In this case, you run a process saved in your Plumsail account (under Processes). The resulting file will be stored in the process history, where you can download it.
If you’re using this approach, please check your template: what is the cell format? The format should match the expected data type (e.g., number/text).
If the formats look correct and the issue still persists, please send us the payload and the result file so we can investigate further.
This action generates an XLSX file using the data you either map from a previous Zap step or enter manually in the action fields. You can also select the Locale setting in this case.
After the Plumsail Documents step, you can add another Zap step to save the file to OneDrive or send it by email. Please refer to the example in our article.
Please let me know which approach you’re using (or prefer). If needed, you can send the files to support@plumsail.com and reference this conversation so we can investigate the issue.
Best regards,
Aleksandra
Plumsail team
I went with approach 1.
I’ll reach out to the support e-mail as the template I used has the cell format at number but it doesn’t seem to help.
