09-19-2007 3:36 PM
Hi Gurus,
i got a requirement to transfer data into application server.
how to upload a <b>txt file</b> to application server's folder in <b>excel</b> format?
while transfering data into excelfile from text file...the numeric fields are
not displaying the exact values in excel sheet.
Example:
in text file the values are:01/01/2007
in excel sheet it is displaying: 1/1/2007.
for both month and date it is not showing the '0'.
Please help me.
09-21-2007 8:07 AM
just chage the operating systems settings then it will come as 07/19/2007
09-21-2007 8:09 AM
go to regional settings and there change the format which ever u want.
ex: 09/11/2007 or 9/11/2007 ok