taking data from a db into the spreadsheet, and I have a column that is numbers, but they start with a zero (0123456789)
When the data goes in it is ok, but any edits to the cells that also contain a zero ie 01234, will turn into 1234.
How can I stop this from happening, as I require the leading zero to be there.
I would think this would also apply to any new lines been added, I would need this been stopped also.
Many thanks
1 Answer, 1 is accepted
0
Hi Kevin,
You could set the number format for the cells or rows or columns you use to text. This can be achieved using the following code:
Or some other number format that suits your needs here you can find more information on how to construct the format strings.
Regards,
Nikolay Demirev
Telerik
You could set the number format for the cells or rows or columns you use to text. This can be achieved using the following code:
this.radSpreadsheet.ActiveWorksheet.Columns[0, 1].SetFormat(new CellValueFormat("@"));Or some other number format that suits your needs here you can find more information on how to construct the format strings.
Regards,
Nikolay Demirev
Telerik
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items