Ankur

Data>Text to Columns>Next>Next>Column Data Format>Date>choose a format>OK

OR..............copy an empty cell.

Select the column and Paste Special>Add>OK>Esc

You will have to re-format the column to Date.


Gord Dibben MS Excel MVP

On Sun, 6 Aug 2006 06:07:01 -0700, Ankur <Ankur@discussions.microsoft.com>
wrote:

>Hi,
>
>When i m calculating the difference between date in the US format downloaded
>from the system it is showing error #VALUE!, however if i manually change the
>date in the column then it calculate the difference.
>
>HOwever as there are lot of datas in excel it will take lot of time. Any
>idea how to do it quickly?
>
>Regards,
>Ankur