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

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 )



TIMFOX123Asked:
Who is Participating?
 
jimyXConnect With a Mentor Commented:
You need to format the cells as Text before adding your data.
0
 
ragnarok89Commented:
format the cell as a date, and specify that particular format. it's available by default:

 Date Format
0
 
Chris BottomleySoftware Quality Lead EngineerCommented:
Format the cells as text, (right click format | number | text) ... but do it before entering any data!

Chris
0
 
jimyXCommented:
Here is a sample:
Sample.xls
0
 
TIMFOX123Author Commented:
thank you all.  

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

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.