Kinetic - Export to Excel in grids have the dates with a timestamp. Is there a way to keep the date format but without the T00:00:00?

Kinetic ERP
21

Decimal with >>>,>>>,>>>,>>9.99 format

22

It was all enabled but I disabled it and still the same behavior

1 Like
23

Also paste as text or values only, either right click or Ctrl-Alt-V. Somewhere in the grid presentation formatting there’s a if null then "0" injecting zeroes as text in numeric columns. Paste-as-text drops all that formatting mess.

And if you paste over the previous values in Excel, you’re pasting into whatever datatypes those cells decided they should be. Throw out those cells first. Highlight and delete the columns first with right click or Ctrl-minus.

When Excel refuses to think something is a date, you know things have gone off the rails.

6 Likes
24

Right? It LOVES to think ANYTHING is a date.

Comedy What GIF by Paramount+

1 Like