Numbers have spaces

  • Resolved chipegoh

    (@chipegoh)


    2 years, 9 months ago

    Good day I have a Ninja Forms calculation running that populates a result in a hidden field which ultimately gets exported to a google sheet. The values calculate correctly and then appear in the google sheet as required, but all the numbers have a space in them (e.g. 3 000) which means that the google sheets do not recognize them as numbers. How can I ensure that calc values do not have spaces when transferred to the google sheet?

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author westerndeal

    (@westerndeal)

    Hello @chipegoh
    Thanks for getting in touch,

    You can select the calculated numbers column, click on format, and set it with Numbers or currency!!

    Hope this helps!

    Thanks
    Abdullah

    Thread Starter chipegoh

    (@chipegoh)

    Hi @westerndeal, unfortunately the above solution does not work… I have formated the relevant columns as numbers, but this does not resolve the issue. It’s only hidden fields that give me this issue. Every other field is fine.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Numbers have spaces’ is closed to new replies.