Leading zeros disappear

  • Resolved jonhs

    (@jonhs)


    7 years, 9 months ago

    This has been asked before and no solution has been offered. Please keep this question open to replies.

    Problem: When submitting e.g. phone numbers and zip codes the leading zeros disappear even if the cells in the drive document are set to plain text. This is a big problem. There is hardly anything that Google will change because it works just fine when typing in the numbers manually in the sheet. The problem appears only when the plugin submits the numbers into the sheet.

    In Google Sheet you can keep the leading zeros (000123) by making the cells plain text or by placing an ‘apostrophy infront of the numbers like this: ‘000123. Maybe this apostrophy can be added to the plugin somehow? A function: if leading zeros are used aphostrohy is added.

    • This topic was modified 7 years, 9 months ago by jonhs.
    • This topic was modified 7 years, 9 months ago by jonhs.
    • This topic was modified 7 years, 9 months ago by jonhs.
Viewing 5 replies - 1 through 5 (of 5 total)
  • Thread Starter jonhs

    (@jonhs)

    7 years, 5 months ago

    Any updates/ideas how to save phone numbers and zip codes without losing the leading zeros when saved in Sheets? Major problem, isn’t it?

    Plugin Author WesternDeal

    (@westerndeal)

    7 years, 5 months ago

    Hello Jonhs,
    You can try this
    — Changing the cell format to Plain Text via Format>Numbers>Plain Text will keep leading zeros.
    or
    — Format > Number > More Formats > Custom number format…

    Refer this for more help
    https://webapps.stackexchange.com/questions/35526/leading-zeros-in-google-spreadsheet-automatically-removed

    https://productforums.google.com/forum/#!topic/docs/Msvwf5ePSdQ

    I suggest you to go for PRO version,
    https://www.gsheetconnector.com/cf7-google-sheet-connector-pro
    Which helps to automate the sheets.. with unlimited sheets.

    Let me know if you have any questions.

    Thanks
    Abdullah

    Thread Starter jonhs

    (@jonhs)

    7 years, 5 months ago

    Thanks Abdullah, but I tried all those with no luck.

    Plain text format works when typing into the Sheet cell, but stops working when the plugin saves into info the same cell.

    Custom number format: I tried different settings, but nothing worked.

    The zeros are saved in the sheets-document only if I type ‘00123 in the contact form. Can’t have the apostrophe pre-filled in my forms.

    Can’t do anything with Pro version if it has the same problem. Idea is to save all forms into 1 sheet.

    Plugin Author WesternDeal

    (@westerndeal)

    7 years, 5 months ago

    Did you try following ?

    At your google sheet click the cell where you want to enter phone number or zipcode and choose Format → Number → More formats → Custom Number Format. Enter this format for eaxmple as : 0########## . This tells Google Sheet that we will enter 10 digits, represented by the hash characters post-fix with 0 and it should show up as shown in the format.

    Now paste 8881231219 into the contact form cell and it will be displayed as 08881231219

    Hope this helps.
    Regarding PRO it will manage in the same sheet, but in a advanced way, you can manage with data/time and much more CF7 functions.
    Let us know further if you have any further queries or if did not worked the above solution.

    Thanks
    Abdullah

    Thread Starter jonhs

    (@jonhs)

    7 years, 5 months ago

    A zip code can look like any of these:
    00123
    01234
    12345

    A phone number can be:
    09 12345
    +3585012345
    0501234567

    Therefore we can’t predict if the number has any zeros or 1 or 2.

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

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