Solved

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

Posted on 2011-03-21
5
277 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
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

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Article by: dandraka
There are several quick shortcuts that can make your life easier in Microsoft Programs.  These simple tips and tricks will your work more productive and you faster at completing your tasks! MS Word (1) Creating Re-usable Scraps You can create s…
This article will show you how to use shortcut menus in the Access run-time environment.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

707 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now