?
Solved

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

Posted on 2011-03-21
5
Medium Priority
?
286 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 2000 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
Cancel future meetings from user mailboxes in Office 365 using Remove-CalendarEvents
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.
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…

749 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