try this link
http://code.google.com/p/openexcel/downloads/detail?name=OPEN_XL.zip&can=2&q
On Sat, Apr 16, 2011 at 11:03 AM, OpenExcel.com <26may.1...@gmail.com>wrote:
> Hi Bhushan,
>
> Files section has been removed from google groups. Go to
> http://www.openexcel.com and click on downloads.
>
Hello Ashish,
My problem is not solve till yet.Awaiting for the reply.
The download link of the Open Excel addin is unavailable on
http://www.openexcel.com
The unavailable link is
http://excel-macros.googlegroups.com/web/OpenXLBeta1.0.0.0.zip?gda=7UqvmUcAAABeK1bCvIVb6K29sqTYZWWthiVAWnx9NyJFXKN
by Text to Column you change its format.
Short Key is ALT+D+E
Select *Delimited -> Click Next -> Click Next -> Select Date Format
(DMY) -> Click Finish*
On Fri, Apr 15, 2011 at 8:34 AM, Mohd Sanusi Mohd Noor
wrote:
> Dear all,
>
> Would like to seek your kind assistance/help on the date f
http://code.google.com/p/openexcel/downloads/detail?name=OPEN_XL.zip&can=2&q
=
On Fri, Apr 15, 2011 at 10:26 AM, ashish koul wrote:
> try this
>
> =SUBSTITUTE(B3,".","-")-SUBSTITUTE(A3,".","-")
>
> On Fri, Apr 15, 2011 at 8:34 AM, Mohd Sanusi Mohd Noor <
> sanus...@gmail.com> wrote:
>
>> Dear
try this
=SUBSTITUTE(B3,".","-")-SUBSTITUTE(A3,".","-")
On Fri, Apr 15, 2011 at 8:34 AM, 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.
> Is
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.
Is there any way/method to change the dates from text to date format.
Attached is the sample data for reference.
The assistance on th
