Extra Formatting before my number in Google sheet
Status: Open · Asked by mikec29526 on · 0 views
Task History ID: IjU3NjMwNTY4MDYzMDA0Mzc1MjZiNTUzNzUxMzI1MTY0NTQzMiI_3D_pc
I have a workflow ID
IjU3NjMwNTY4MDYzMDA0Mzc1MjZiNTUzNzUxMzI1MTY0NTQzMiI_3D_pc
Whenever it posts to Google sheets, in the column B, it puts $ before the number. So if it is $40.00, it puts $40.00
Is there a way to fix that?
Hey @mikec29526
Since it is possible that the row entries might be edited from your Google Sheets format itself, so make the column of your Google Sheets have "Plain Text" selected.

It still did that despite have the entire column in plain text mode on Google sheets. Any other suggestion?
Could you please record a short screen recording executing the workflow and showing how the amount is added to your Google Sheets?