tags:

views:

24

answers:

2
Q: 

Excel automatically converts to date?

I have an excel file that always converts k 6-8 to a date. Is there anyway to not make this happen? I have tried making a plain text field to prevent this and still no luck. Any ideas?

+1  A: 

put a tick in front of it so instead of k 6-8 do 'k 6-8

SQLMenace  2010-08-09 20:05:24
A: 

Try putting an apostrophe (') before the 6-8 to force it to text.

theproxy  2010-08-09 20:05:52

related questions

Given a Date Object how do I determine the last day of its month?
Is there an easy way in .NET to get "st", "nd", "rd" and "th" endings for numbers?
VB.NET on Vista, trying to get date (Today) causes security exception
DateTime.Now vs. DateTime.UtcNow
DateTime Utility for ASP.net
Regular Expression to match valid dates
Batch file to delete files older than N days
How Would You Programmatically Create a Pattern from a Date that is Stored in a String?
How do You Build a Date or Calendar Object From a String in Java?
Get Last Day of the Month in Python
How do I get the difference between two Dates in JavaScript?
sql missing rows when grouped by DAY, MONTH, YEAR
What is the regex pattern for datetime (2008-09-01 12:35:45 ) ?
How do i get today's date in C# in 8/28/2008 format?
What's the simplest way to decremement a date in Javascript by 1 day?
How can I format a javascript date to be serialized by jQuery
Ruby / Rails pre-epoch dates on windows
If I have a PHP string in the format YYYY-DD-MM and a timestamp in MySQL, is there a good way to convert between them?
How to display "12 minutes ago" etc in a PHP webpage?
Dealing with PHP server and MySQL server in different time zones
Creation Date of Compiled Executable (VC++ 2005)
T-Sql date format for seconds since last epoch / formatting for sqlite input
Date arithmetic in Unix shell scripts
What is the best way to wrap time around the work day?
Localising date format descriptors