I need the option to be in USD currency when it comes through to my spread sheet. Is this possible?

  • Profile Image
    FuturisticInfinity
    Asked on October 12, 2018 at 05: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



    This is a re-post of a comment on How to Inject Custom CSS Codes

  • Profile Image
    Victoria_K
    Answered on October 12, 2018 at 06: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. 

  • Profile Image
    FuturisticInfinity
    Answered on October 12, 2018 at 06: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
    ...
  • Profile Image
    Kiran
    Answered on October 12, 2018 at 09: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.png

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