09-10-2008 2:14 PM
Hi Guys,
I am downloading the data into Excel, where several fields contains date values and were defined with char10. When i right click on a cell containing date value and choose format option its showing *dd/mm/yyyy and cell which has blank value show General format instead dd/mm/yyyy
Please sugguest to resolve this issue.
Regards,
Narendra.
09-10-2008 2:30 PM
Select the date cell that has the required date format defined. Click on 'Format Painter' Icon. Click and drag the cursor on to the cells (or columns) that you require to change the date format.
09-11-2008 5:53 AM
Should handle in Program itself not after download, Guys any help?
09-11-2008 11:07 AM
If you want to handle in Program itself have the date value filled in as '00/00/0000' (while downloading to excel and make this field as char) if no date value is present.
Thanks,
Mahesh
09-11-2008 6:02 AM
Hi,
Select the date cell that has the required date format defined. Right Click on the date formaat and select the 'Format cells' after go to select the custom after that u will give the which date format u want .
Thanks.
Ashok,
09-11-2008 6:05 AM
Change Date format in Your system.
Go to Start->setting->Controll pannel->regional setting
and change date format as DD.MM.YYYY and separater as "."
it will solve your problem.
Regards
Rajiv singh
09-11-2008 6:07 AM
hello sir,
I think it is PC date format problem in excel , go to control pannel , select "change the formate of numbers,date,time
display menu here U change date format as you like then save
sree hari
09-11-2008 6:21 AM
hi narendra,
righe click on the cell, go to "Format cell' and in number tab click on "custom",then u type your custom type like dd/mm/yyyy.
Thanks,
Mahesh.