| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
csv format changes numbers
I need to save my file in a csv format. When the file is reopenned, some of
the numbers are in a date format and others are in exponential format. How can I format the number to keep the numbers from changing format. I have tried various formats before savint the file. In this instance, the numbers represent part numbers and the file is being imported into my business software to update pricing. -- Bob |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
csv format changes numbers
If you are re-opening in Excel, the behaviour you describe is typical.
Have you tried opening the *.csv file in Notepad or similar application? Gord Dibben MS Excel MVP On Wed, 21 May 2008 07:04:01 -0700, Bobbr wrote: I need to save my file in a csv format. When the file is reopenned, some of the numbers are in a date format and others are in exponential format. How can I format the number to keep the numbers from changing format. I have tried various formats before savint the file. In this instance, the numbers represent part numbers and the file is being imported into my business software to update pricing. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert german format numbers to british format | Excel Discussion (Misc queries) | |||
| Convert numbers from text format to number format | Excel Discussion (Misc queries) | |||
| excel numbers in general format i cant add cant change format | Excel Worksheet Functions | |||
| How do i change numbers in text format to number format? | New Users to Excel | |||
Hybrid Mode
