I need the option to be in USD currency in my spread sheet

  • FuturisticInfinity
    Asked on October 12, 2018 at 5:05 AM

    Can anyone help me with css code i picked a multi option for my form but i really need the option to be in USD currency when i come through to my spread sheet. Is this possible? All help will be appreciated

    Thanks

  • Victoria_K
    Replied on October 12, 2018 at 6:05 AM

    Hello,

    It seems that you refer to this form Infinity I Registration Form 

    But, unfortunately, I am not sure what exactly is the task. Can you please provide us some more information?

    We will wait for your reply. 

  • FuturisticInfinity
    Replied on October 12, 2018 at 6:43 AM
    Ive put a option on my form And its to select the $200.00usd option but i
    cant get it to come threw to my spread sheet as a currency
    ...
  • Kiran Support Team Lead
    Replied on October 12, 2018 at 9:33 AM

    I am sorry that I am not sure if I understand your query correctly. Do you mean to downloading the submissions to Excel spreadsheet or with Google Spreadsheet with changing the column as Currency format not displaying as currency? 

    If so, since the option is having USD text, the column in the spreadsheet may be treated as text field and so not displaying as currency. You may consider displaying the USD in the field label and only the amount in the option so that the spreadsheet can treat the number received in the currency format.

    153935118512102018 191049 Screenshot 10

    Hope this information helps! Let us know if you are referring something different. We will be happy to help.