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. Image for the cookie policy date
close icon

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


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.


1 Reply

SK Shanmugaraja K Syncfusion Team 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 

Live Chat Icon For mobile
Up arrow icon