Title: Leading 0
Last modified: May 13, 2019

---

# Leading 0

 *  Resolved [salopianfella](https://wordpress.org/support/users/salopianfella/)
 * (@salopianfella)
 * [7 years, 2 months ago](https://wordpress.org/support/topic/leading-0/)
 * Hi,
 * I have a lot of tables that hold telephone information which have 11 digits and
   a leading 0. This is accomplished in Excel by simply using a custom format with
   eleven zeros. When I import these tables the leading zero is missed off. Is there
   a way add a prefix to all the cells in a tablepress column?
 * Many thanks,
 * Lyndon

Viewing 1 replies (of 1 total)

 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [7 years, 2 months ago](https://wordpress.org/support/topic/leading-0/#post-11527053)
 * Hi,
 * thanks for your post, and sorry for the trouble.
 * Please try saving the table to a CSV file in Excel, and then import that. This
   should keep the leading zeros.
 * Regards,
    Tobias

Viewing 1 replies (of 1 total)

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

 * ![](https://ps.w.org/tablepress/assets/icon.svg?rev=3192944)
 * [TablePress - Tables in WordPress made easy](https://wordpress.org/plugins/tablepress/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/tablepress/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/tablepress/)
 * [Active Topics](https://wordpress.org/support/plugin/tablepress/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/tablepress/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/tablepress/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * Last activity: [7 years, 2 months ago](https://wordpress.org/support/topic/leading-0/#post-11527053)
 * Status: resolved