Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-12-2013, 09:11 AM
mariocesar mariocesar is offline How to see original numbers on a CSV file Windows XP How to see original numbers on a CSV file Office 2007
Novice
How to see original numbers on a CSV file
 
Join Date: Dec 2013
Posts: 1
mariocesar is on a distinguished road
Default How to see original numbers on a CSV file


I have an Excel workbook with a column of more than 35 numbers in it, when I save the file as CSV file because I'm importing in to Indesign later, the field with the 35 numbers changed to a different digit and also lettering, how can I the same numbers from original file.
Reply With Quote
  #2  
Old 12-12-2013, 03:37 PM
SteveWcg SteveWcg is offline How to see original numbers on a CSV file Windows 7 64bit How to see original numbers on a CSV file Office 2013
Novice
 
Join Date: Jun 2013
Location: Sydney Australia
Posts: 22
SteveWcg is on a distinguished road
Default

I can't really replicate it but it sounds like excel is converting the number to scientific formula on saving it. This can happen when you have numbers as text and you choose the convert to number option in the drop down option, see picture.


Before you save the file select the numbers and convert them to text. If you save them in scientific format it looks like the before in the example but if you save them as numbers it looks like the after
Attached Images
File Type: png tonum_before.png (7.4 KB, 7 views)
File Type: png tonum_after.png (2.9 KB, 13 views)
File Type: png example.png (9.8 KB, 7 views)
Reply With Quote
  #3  
Old 12-13-2013, 07:51 PM
BobBridges's Avatar
BobBridges BobBridges is offline How to see original numbers on a CSV file Windows 7 64bit How to see original numbers on a CSV file Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

I don't know Indesign from a hole in the ground, but you can't control the format of what's stored in CSV except, as SteveWcg says, by converting to text strings. I don't recommend that, though; I'm assuming you want to import numeric values at the other end. I can't visualize exactly what the problem is; perhaps you could post the CSV and explain exactly how it isn't what you wanted?
Reply With Quote
  #4  
Old 12-15-2013, 10:06 PM
macropod's Avatar
macropod macropod is offline How to see original numbers on a CSV file Windows 7 32bit How to see original numbers on a CSV file Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by mariocesar View Post
I have an Excel workbook with a column of more than 35 numbers in it, when I save the file as CSV file because I'm importing in to Indesign later, the field with the 35 numbers changed to a different digit and also lettering, how can I the same numbers from original file.
Since Excel has only a 15-digit precision, any longer numeric string would already have to be stored as text. Such a string will be stored as such in the CSV. You can confirm that by opening the CSV file with a text editor like NotePad. Re-open the CSV in Excel, though and all you'll see is a number like 1.23456789012345E+39. Thus, this is a problem with the way Excel opens CSV files, not with how it stores CSV data.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
'Save As' to same folder as original opened file thepuppyprince Office 0 01-18-2013 08:13 AM
How to see original numbers on a CSV file Copy outline numbering retaining original numbers PatPat Word 7 08-20-2012 09:03 AM
How to see original numbers on a CSV file Excel 2010 deleting original file and .tmp msduh Excel 1 04-09-2012 05:36 AM
How to restore original data format - from a .pdf file to Excel columns KIM SOLIS Excel 1 09-18-2011 10:49 PM
How to see original numbers on a CSV file How to combine many word files in one file but to have correct pages numbers and tabl Jamal NUMAN Word 6 04-20-2011 02:32 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:46 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft