Leading zeros

  • Resolved petebm

    (@petebm)


    5 years, 4 months ago

    Hi again

    I realise this is not a problem with this plugin, but ask the question here as it’s something other users may have found a way around, or maybe there’s something clever I can do with the plugin; I hope that’s OK – feel free to close the topic if not.

    It’s the old chestnut of Excel stripping the leading zero from phone numbers; it is there in the custom field stored by my Ultimate Member form, and I’ve set the field type in this plugin to Text – but still Excel strips that zero. What I’d dearly love is some way to ensure that it stays there without messing around with the csv file (eg opening it in Notepad, where it’s still there) – I want to be able to just double-click & have it open correctly.

    The only thing I can think to do otherwise is add ‘Please include spaces‘ to the field on the form, and add a placeholder of 01234 567890 as a hint.

    Thanks!
    Pete

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

    (@sebet)

    5 years, 3 months ago

    Hello @petebm,

    Just a heads up that I’ve added the ability to add spaces on cells containing numbers. You can now add a space on a specific position to keep leading zeros.

    Thread Starter petebm

    (@petebm)

    5 years, 3 months ago

    Hi @sebet

    That’s great, thank you. I’ll experiment with setting the value of N to 0, since I can’t predict where a space will need to occur in a phone number as entered by people in different countries etc, so I just need to ensure the whole cell gets treated as text.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Leading zeros’ is closed to new replies.