Title: Problem with string starting with ZERO
Last modified: June 26, 2017

---

# Problem with string starting with ZERO

 *  Resolved [andomp](https://wordpress.org/support/users/andomp/)
 * (@andomp)
 * [8 years, 11 months ago](https://wordpress.org/support/topic/problem-with-string-starting-with-zero/)
 * When i write a number eg. 01717981055
    in the email i see the correct number,
   in the google sheet i see 1717981055 whitout starting ZERO.
 * How can i fix it?
 * Thanyou

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

 *  [SamWired](https://wordpress.org/support/users/samwired/)
 * (@samwired)
 * [8 years, 10 months ago](https://wordpress.org/support/topic/problem-with-string-starting-with-zero/#post-9296956)
 * +1 Same issue for me, tried formatting the column as plain text but keeps reverting
   to automatic
 *  Thread Starter [andomp](https://wordpress.org/support/users/andomp/)
 * (@andomp)
 * [8 years, 10 months ago](https://wordpress.org/support/topic/problem-with-string-starting-with-zero/#post-9338943)
 * i’ve used a workaround
 *  $( “#sndcntfrm” ).click(function() {
    var phone = $(‘input[name=”your-phone”]’).
   val(); if (phone.startsWith(‘0’)) { $(‘input[name=”your-phone”]’).val(“.+39″+
   phone); } });
 * sndcntfrm is the contact form submit button id.
 * The dot before international prefix is for Google Sheets
    requirements ([https://webapps.stackexchange.com/questions/33202/how-to-set-a-google-docs-spreadsheet-cell-format-to-bare-text](https://webapps.stackexchange.com/questions/33202/how-to-set-a-google-docs-spreadsheet-cell-format-to-bare-text))
 * I hope this help
 *  Plugin Author [WesternDeal](https://wordpress.org/support/users/westerndeal/)
 * (@westerndeal)
 * [8 years, 7 months ago](https://wordpress.org/support/topic/problem-with-string-starting-with-zero/#post-9632594)
 * Hello [@andomp](https://wordpress.org/support/users/andomp/) [@samwired](https://wordpress.org/support/users/samwired/)
 * It looks like there is an issue with the Google sheet formatting, you can set
   the column as an plain text and it will work perfectly,
    Already tested on our
   development server and looks everything is working perfect,
 * let us know if still you have any issue..
 * Thanks
    Abdullah

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

The topic ‘Problem with string starting with ZERO’ is closed to new replies.

 * ![](https://ps.w.org/cf7-google-sheets-connector/assets/icon-128x128.gif?rev=
   3232650)
 * [GSheetConnector for CF7 – Connect Contact Form 7 to Google Sheets and Send Form Submissions in Real Time](https://wordpress.org/plugins/cf7-google-sheets-connector/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/cf7-google-sheets-connector/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/cf7-google-sheets-connector/)
 * [Active Topics](https://wordpress.org/support/plugin/cf7-google-sheets-connector/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/cf7-google-sheets-connector/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/cf7-google-sheets-connector/reviews/)

## Tags

 * [format](https://wordpress.org/support/topic-tag/format/)

 * 3 replies
 * 3 participants
 * Last reply from: [WesternDeal](https://wordpress.org/support/users/westerndeal/)
 * Last activity: [8 years, 7 months ago](https://wordpress.org/support/topic/problem-with-string-starting-with-zero/#post-9632594)
 * Status: resolved