difference between dates

[Ankur]

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

[excelent]

try
=SUBSTITUTE(A1;" ";"")
or
=SUBSTITUTE(A1;"'";"")
or
=SUBSTITUTE(A1;"""";"")
or
=A1*1


"Ankur" skrev:

> 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

[Gord Dibben]

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