Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / May 2008

Tip: Looking for answers? Try searching our database.

csv format changes numbers

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Bobbr - 21 May 2008 15:04 GMT
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.
Signature

Bob

Gord Dibben - 22 May 2008 00:39 GMT
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

>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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.