Enable Leading Zero - Printable Version +- 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 |