+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: UFT / QTP Beginners (https://www.learnqtp.com/forums/Forum-UFT-QTP-Beginners)
+--- Thread: Enable Leading Zero (/Thread-Enable-Leading-Zero)
Enable Leading Zero - Nana - 06-06-2008
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.
RE: Enable Leading Zero - Nana - 06-06-2008
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.
RE: Enable Leading Zero - somisays - 06-06-2008
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
RE: Enable Leading Zero - Nana - 06-06-2008
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.
RE: Enable Leading Zero - somisays - 06-06-2008
Dear Nana,
Select custom number and then you can see more formats or you can add your own format.
Regards
Sridhar
RE: Enable Leading Zero - niranjan - 06-07-2008
Use " ' " infront.
Example: for 001 use '001