I have a large number (13 digits) and when I save as csv from xls the number format is wrong and the numbers apears with zeros in the end.
I have a large number (13 digits) and when I save as csv from xls the number format is wrong and the numbers apears with zeros in the end.
A csv file will not store number formats. It is a simple text file.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
So if I have a number with 13 digits why I cant make it csv? as tect chr.?
I don't have a problem with that. Can you zip and post sample files, Excel & CSV?
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
I have one cell with a number 123456789012 after save as csv the number becomes 123457000000.
On my test I get
123456789123456
That's why I asked for sample files.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'