That solution, although not entirely wrong, would not work on all
computers.
This is mainly caused because there are many potential problems :
1) the date items separator (here ".")
2) the date structure of the text field (here it is "ddmm")
3) the date structure as used by your system (could
try this
=SUBSTITUTE(B3,".","-")-SUBSTITUTE(A3,".","-")
On Sun, Apr 17, 2011 at 5:41 PM, Mohd Sanusi Mohd Noor
wrote:
>
> Dear all,
>
> Would like to seek your kind assistance/help on the date format.
> I've a data on date derive from SAP, when transfer to excel the date is in
> text format.
> I
