Excel Formatting

  • Thread starter Thread starter msu
  • Start date Start date
M

msu

Hi,
I often have to import or copy long list of names (text) in excel and
if when one of this names is something like Sept8, excel automatically
recognize this as a date format and transform this into e.g. 1.09.2008.
Once excel has done this there is no way back to the original text entry
even using the "format cell" options. Is there a way just to turn of
this automatic recognition system of excel, or to fix the default to
text format.
Thanks for help,
M
 
This might not be the answer you're looking for, but if you enter an
apostrophe as the first character in a cell, it should display the text
exactly as it's listed. Ex: Currently A1=Sept8 ==> Change to:
A1='Sept8...
hth,

Paul
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excell 2021 0
Editing conditional formats (Excel 2010) 15
Formatting Cells - Hex Values 3
Index/Match with text-looking numbers 1
Conditional formatting based on length of the cell contents 5
Date formats in Excel 2003 under Vista 5
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
date format in excel imported from an SQL DB. 2

Back
Top