From: mully <david.mullet@...>
Date: 2007-03-06T02:00:05+09:00
Subject: Re: Excel date conversion

On Mar 5, 9:38 am, WKC CCC <wai-kee.ch...@uk.bnpparibas.com> wrote:
> Is there a way to convert the excel date number i.e. 34516 into a
> datestring: 01-Jul-94
>
> Thanks
>
> --
> Posted viahttp://www.ruby-forum.com/.

Here's something to keep in mind (if you don't already): A cell in
Excel has a Value property and a Text property. The Value property
returns the underlying data as Excel has stored it. The Text property
returns the formatted text as displayed to the user.

irb(main):010:0> ws.Cells(3, 1).Value
=> "1994/07/01 00:00:00"
irb(main):011:0> ws.Cells(3, 1).Text
=> "01-Jul-94"

So, if the cell is already formatted as you wish, just call the Text
property rather than the Value property.

Hope that helps.

David