Pretty sure. Unless you use a source file type that might contain formatting info, Excel is trying to be helpful by making educated guesses about the contents of a cell.
--
rk
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Laurie Alvey Sent: Wednesday, September 20, 2017 10:09 AM To: profoxtech@leafe.com Subject: Re: [NF] Excel Text formatted cells converting to scientific notation when saving as csv
IMHO, another reason to avoid CSV files. Does the same happen if the worksheet is saved as, say ,text tab delimited?
Laurie
On 20 September 2017 at 13:29, Richard Kaye rkaye@invaluable.com wrote:
This also happens with international phone numbers. You can also use the cell format for zip codes - 00000
Want to see what the actual format of a cell is via automation? Fire up Excel, add some value to a cell and apply a format.
ox=GETOBJECT(,[excel.application]) ?ox.ActiveCell.Value ?ox.ActiveCell.Text ?ox.ActiveCell.NumberFormat RELEASE ox
--
rk
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Michael Madigan Sent: Wednesday, September 20, 2017 8:19 AM To: profoxtech@leafe.com Subject: [NF] Excel Text formatted cells converting to scientific notation when saving as csv
I thought I'd pass this tip along. If you have large text fields with numeric values, like insurance policy numbers or UPC Codes, you have to format the cell with custom type ############### or similar, otherwise the CSV file gets scientific notation values, even if the cell is of type text. Hope this saves someone some time.
[excessive quoting removed by server]