Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 05-03-2011, 05:54 AM
OTPM OTPM is offline How Do I Put Text Values Into A CSV That Excel Will Leave Along? Windows 7 32bit How Do I Put Text Values Into A CSV That Excel Will Leave Along? Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi
Two things you could try:
1. for those "numeric values" you do not want Excel to treat as numbers you need to put a single quote in front of the entry. This forces excel to treat the entries as text.
2. Format the relevant column in Excel as text.
The first option should do the trick though.
Hope this helps.
OTPM
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
How Do I Put Text Values Into A CSV That Excel Will Leave Along? Generate chart from list of text values knownunknown Excel 6 04-24-2013 01:56 AM
How Do I Put Text Values Into A CSV That Excel Will Leave Along? help with formulate refers to values meninio Excel 11 01-26-2011 10:00 AM
How Do I Put Text Values Into A CSV That Excel Will Leave Along? Download to Outlook, leave msg copies on server? Msuser Outlook 2 01-12-2011 05:54 PM
How Do I Put Text Values Into A CSV That Excel Will Leave Along? Using Conditions to Add Values EclipticalD Excel 1 07-08-2010 09:50 PM
Word - Calculate and paste values from Excel sheet Augf87 Word 1 07-06-2009 10:26 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:20 AM.


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