How to show empty date field in Excel ? - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

How to show empty date field in Excel ?

Message

De

14/11/2002 23:44:38

Garrett Fitzgerald
Penobscot Community Health Care
Maine, États-Unis

À

14/11/2002 23:32:20

Handi Rusli
PT. Alam Sumbervita
Jakarta, Indonésie

Information générale

Forum:

Visual FoxPro

Catégorie:

Codage, syntaxe et commandes

Titre:

Re: How to show empty date field in Excel ?

Divers

Thread ID:

00723055

Message ID:

00723058

Vues:

10

>Anybody know how to show empty date field in Excel
>using PivotTable Automation (VFP Foundation Class)?
>Excel converts blank dates with "01-01-1900". Any
>issues around this ?

The first thing that comes to mind is changing the empty dates into NULL dates. The second thing is running a macro in Excel that blanks those fields out.

My blog
My consulting page
My home page

Member of the Trim Your Auto-Quote Campaign!
What's another word for thesaurus?

Click here to load this message in the networking platform