Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 06-24-2014, 01:54 PM
gebobs gebobs is offline Display Numbers in CSV file over 15 digits Windows 7 64bit Display Numbers in CSV file over 15 digits Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Open the file while in Excel (i.e. File:Open).
On the bottom right of the Open File dialog box.
Select your file and click Open.
Click Next twice to get to Data Format selection dialog.
Select Text for Column Data Format.
Click Finished.

I tried it with just one number and it worked. Your results may vary.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to replace digits with letters Bananabean Word VBA 6 09-14-2013 09:28 PM
Separate the digits into 3 combinations Jasa P Word VBA 1 08-19-2012 11:04 PM
Display Numbers in CSV file over 15 digits Problems merging in last 4 digits of an account higher than 16 digits Glynda Mail Merge 1 04-08-2011 12:17 AM
Display Random Numbers as Transition greenbutton PowerPoint 0 03-09-2011 04:43 PM
How to delete first 6 Digits and one Space from a CELL? Learner7 Excel 3 08-10-2010 04:06 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:18 PM.


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