05-05-2006 8:09 AM
I want the Excel Cell to hold value 002. But If we enter the values thru the Program, it just displays 2. Tell me how to retain zeroes on the left. Ex: Account No. 000123456789.
05-05-2006 8:17 AM
just open xls sheet.
right click on coloumn.
click format cells
select text option.
click ok.
now u can insert 002.
05-05-2006 8:34 AM
Hi Venkat,
You need to change the property of the column to text else Excel cuts the leading zeros..
U can set it to text in the format cell option..
No change is required from the program end..
Regards,
Tanveer.
Please mark if found helpful..
05-05-2006 9:10 AM