export-csv changes cell value with export-csv ...but value is correct in txt
hello. thanks time. i had question in regards how spit out result. i exporting computer systems information users. when export using export-csv cell values overwritten excel numeric value (i.e. if serial number 12346789449 ... excel changes 1.4e2 ... don't want since ruining results. when export text file result works not in column format. so looking either excel stop converting value or how export in txt in column format. i tried format-table no go. machinetype : desktop machinename : mycomputer machinemodel : dell machineserial : 134rfh44433 machineos : windows so how can column format? thanks. this no powershell problem! excel issue! excel automatically convert formats other format during csv import. includes numbers leading zeros, date / time conversions, currency , fo...