Solved

How in excel do I format as absolutely text, don not mess with it at all !!

Posted on 2011-03-21
5
283 Views
Last Modified: 2012-05-11
I need my data exactly as I put it in.
one field is:
2011-03-27
even formated as "text" Excell likes to play with it.  j
the old trick of putting a single quote in front of it can not work here because I can not
have it here.   This feeds a script into another app.  

Notepad does it but I want to have mutiple records  ( info on servers )



0
Comment
Question by:TIMFOX123
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 24

Accepted Solution

by:
jimyX earned 500 total points
ID: 35184147
You need to format the cells as Text before adding your data.
0
 
LVL 8

Expert Comment

by:ragnarok89
ID: 35184161
format the cell as a date, and specify that particular format. it's available by default:

 Date Format
0
 
LVL 59

Expert Comment

by:Chris Bottomley
ID: 35184174
Format the cells as text, (right click format | number | text) ... but do it before entering any data!

Chris
0
 
LVL 24

Expert Comment

by:jimyX
ID: 35184176
Here is a sample:
Sample.xls
0
 

Author Closing Comment

by:TIMFOX123
ID: 35184223
thank you all.  

Sorry I think Jimmy had it and others pretty much agreed with his solution.  
Thank you all
0

Featured Post

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question