You might want to consider not using Excel for viewing csv files. Excel often doesn’t show you the data exactly as it is in the file. It can change formats of dates, times and numbers (as you have seen). And then if you “Save’ then it writes out the changes values to the csv file.
Dani Beaubien Open Road Development > On Nov 6, 2019, at 2:38 PM, Luc Devar via 4D_Tech <[email protected]> > wrote: > > Hi Chuck > > A single apostrophe ' before a number will force Excel to treat a number as > text (including a default left align) > > Luc Devar > ********************************************************************** > 4D Internet Users Group (4D iNUG) > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:[email protected] > ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
