Enable Leading Zero

[Nana]

Hi, I paste a text-formatted number from xls (with leading zero) to the datatable, but the leading zero vanishes and the format is changed to number. How do I preserve the leading zero in the datatable when I paste? Thanks.

[Nana]

I figured I could get this by simply importing from xls, so my problem is solved. Would still be interesting to find out why formats dont get pasted.

[somisays]

Dear Nana,
You can format the data like this.
Select a column to format and right mouse click and select format (depending on your requirement).

Regards
Sridhar

[Nana]

Thanks Sridhar. But the trouble is I dont see a text format. All other types are there. And in the number format, there is no option to enable a leading zero.

[somisays]

Dear Nana,
Select custom number and then you can see more formats or you can add your own format.

Regards
Sridhar

[niranjan]

Use " ' " infront.
Example: for 001 use '001