Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Empty cell shows 12/30/1899
Message
From
01/12/2019 02:35:02
 
General information
Forum:
Microsoft Office
Category:
Excel
Miscellaneous
Thread ID:
01672120
Message ID:
01672124
Views:
53
>I am importing data from an excel into a DBF (using VFPxWorkBookXLSX.VCT). A column that has in some rows value that looks like DateTime. In some other rows it looks empty. When I look at the value retrieved from an empty cell it shows (in Messagebox) as "12/30/1899". Is this how Excel - internally keeps the DateTime but shows empty?
>

l wrote the class that is on VFPx -- can you send me an example spreadsheet that gives this result? Thank you.
Previous
Reply
Map
View

Click here to load this message in the networking platform