I've got a workbook that is writing values from a tab delimited file into a new excel workbook.
Within this, I've got cells that have values that are numbers but need to be formatted as text, as these numbers contain a leading zero.
I'm using the Telerik.Web.Spreadsheet namespace to do this and all seems to be working well until I save the file.
I've inspected my collection before calling the Save method on the workbook and the numbers in the cell are correct (i.e they have a leading zero) but as soon as I call save and open the file, the zeros are removed.
I've checked to make sure that the cells are being correctly formatted as text (they are all text) yet the cell consistently removes the leading zero.
What gives and how can I fix this? I've been at this for two days now and I'm getting nowhere - any help would be GREATLY received.
Kind regards,
Ben