Hi all,
i am extracting data from Ms acess to excel spreadsheet. the datatype in Ms-acess is date. but format of data is not correnct in spreadsheet, few records are left alined i.e. text type.when i try to edit it i found the records are followed by (') apostrophe.below is the output records for your reference....
28/05/2009
15/05/2009
13/05/2009
13/05/2009
05/08/09
05/08/09
05/08/09
05/01/09
23/04/2009
21/04/2009
Please help................
Thanks
G2K
i am extracting data from Ms acess to excel spreadsheet. the datatype in Ms-acess is date. but format of data is not correnct in spreadsheet, few records are left alined i.e. text type.when i try to edit it i found the records are followed by (') apostrophe.below is the output records for your reference....
28/05/2009
15/05/2009
13/05/2009
13/05/2009
05/08/09
05/08/09
05/08/09
05/01/09
23/04/2009
21/04/2009
Please help................
Thanks
G2K