We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

When a cell is of type text, leading zero's are stripped out

Thread ID:





127255 Nov 7,2016 02:59 AM UTC Nov 7,2016 08:54 AM UTC JavaScript 1
Tags: ejSpreadSheet
Asked On November 7, 2016 02:59 AM UTC


I'm trying to use the ejSpreadsheet in an app and want to have a column where users can enter text, which in some cases will contain leading zeros. If I format the cells as text, any content is allowed except for leading zero's, which get stripped off. 

This behaviour is evident on your own demos: 


Select a range of cells, change the type to 'text' using the ribbon then try to enter text with a leading zero. The text 009 gets stripped to 9. This is contrary to how Excel behaves.

Please advise if  there is a way to allow users to enter any text, even if it is multiple 0's followed by a number.


Shanmugaraja K [Syncfusion]
Replied On November 7, 2016 08:54 AM UTC

Hi Grant, 
Thank you for using Syncfusion products, 
We have considered this “When the cell has text type, leading zeros are not maintained” as an issue and a support incident has been created under your account to track the status of this requirement. Please log on to our support website to check for further updates. 
Shanmugaraja K 


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon