• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $249 (🏆Lifetime Access) - View offer

Extra Formatting before my number in Google sheet

mikec29526

Member
Your 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?
 

Supreme

Well-known member
Staff member
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.

1709614163158.png
 

mikec29526

Member
It still did that despite have the entire column in plain text mode on Google sheets. Any other suggestion?
 

ArshilAhmad

Moderator
Staff member
Could you please record a short screen recording executing the workflow and showing how the amount is added to your Google Sheets?
 
Top