Answers
Oct 25, 2022 - 02:11 PM
The short answer is learn to hate Excel - The way it handles dates is at best random unfortunately. We actually output as text but Excel makes it's own mind up. You can play with the date formats in pi to get something that may play better with excel.
My real question is why export to Excel?? Why not do what you need in pi?
My real question is why export to Excel?? Why not do what you need in pi?
Oct 25, 2022 - 02:15 PM
The short answer is learn to hate Excel - The way it handles dates is at best random unfortunately. We actually output as text but Excel makes it's own mind up. You can play with the date formats in pi to get something that may play better with excel.
My real question is why export to Excel?? Why not do what you need in pi?
My real question is why export to Excel?? Why not do what you need in pi?
Add New Comment