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

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

Ankur

DataText to ColumnsNextNextColumn Data FormatDatechoose a formatOK

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

Select the column and Paste SpecialAddOKEsc

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
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