Excel dates

[John Harrison]

When I open an Excel file with ViewXLS dates show correct;y, eg 29.12.25
but if I export the data as CSV and load it into Fireworkz it just appears
as a number, eg 46,020.

The Help file (in Addenda & Errata) says:

'Starting with 2.30, if an applied style (or effect) has a date format
supplied in the number format field, OpenDocument / Microsoft
Excel-compatible serial numbers can be automatically converted to date
values.'

I set the Effect so that Number > Date is dd.mm.yy but the dates still
display as numbers. What am I missing?

--
John Harrison
Website http://jaharrison.me.uk
Using 4té2 and ARMX6, both running RISC OS

The truth is never pure and rarely simple.

[Stuart Swales]

On 18/02/2026 15:09, 'John Harrison' via Colton Software Fireworkz wrote:
> When I open an Excel file with ViewXLS dates show correct;y, eg 29.12.25
> but if I export the data as CSV and load it into Fireworkz it just appears
> as a number, eg 46,020.
>
> The Help file (in Addenda & Errata) says:
>
> 'Starting with 2.30, if an applied style (or effect) has a date format
> supplied in the number format field, OpenDocument / Microsoft
> Excel-compatible serial numbers can be automatically converted to date
> values.'
>
> I set the Effect so that Number > Date is dd.mm.yy but the dates still
> display as numbers. What am I missing?

What it means is that if the source document has a date format applied,
Fireworkz import process can try to use that to convert to a date rather
than the underlying serial number. You can't apply a Fireworkz
style/effect later to achieve this.


--
Stuart Swales

[Alan Adams]

In message <fce2642b-47d6-404b...@gmail.com>

That serial is the number of days since 1/1/1900. You can use that to
convert it back to a date.



--
Alan Adams

[David Ruck]

On 18/02/2026 15:45, 'Alan Adams' via Colton Software Fireworkz wrote:
> That serial is the number of days since 1/1/1900. You can use that to
> convert it back to a date.

You have to take in to account Excel's buggy data handling that thought
1900 was a leap year.

---druck
--
Email: dr...@druck.org.uk
Phone: +44-(0)7974 108301

[John Harrison]

In article <fce2642b-47d6-404b...@gmail.com>,

Stuart Swales <stuart.swale...@gmail.com> wrote:
> if the source document has a date format applied, Fireworkz import
> process can try to use that to convert to a date rather than the
> underlying serial number

How does the Fireworkz import process work? I can't find anything about
importing in the Help.

--
John Harrison
Website http://jaharrison.me.uk
Using 4té2 and ARMX6, both running RISC OS

The Europeans invest to provide value. The Anglo Saxons only invest to reduce costs. (Sir Alister Morton, Chairman of EuroTunnel)