1-4-1 is not a date how do I stop excel from changing whats enter
 

is there anyway to stop the auto format I need to enter
1-4-1
1-4-2
1-4-3 etc...
and the data showes up as dates in the cells I hate this auto function and I
would like to shut all auto features off they never help

1-4-1 is not a date how do I stop excel from changing whats enter
 

Precede your entry with an apostrophe (').

Regards,
Fred

"Perry Monroe" <Perry wrote in message
...
is there anyway to stop the auto format I need to enter
1-4-1
1-4-2
1-4-3 etc...
and the data showes up as dates in the cells I hate this auto function and
I
would like to shut all auto features off they never help

1-4-1 is not a date how do I stop excel from changing whats enter
 

When you enter 1-4-1 you are entering a DATE
To have is as text;
Either pre-format the cells as Text
Or precede the entry with a single quote (apostrophe) as in '1-2-3
This will no be visible in the cell or on printout
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Perry Monroe" <Perry wrote in message
...
is there anyway to stop the auto format I need to enter
1-4-1
1-4-2
1-4-3 etc...
and the data showes up as dates in the cells I hate this auto function and
I
would like to shut all auto features off they never help

1-4-1 is not a date how do I stop excel from changing whats enter
 

Enter an apostrophe before your data

'1-4-1
'1-4-2

"Perry Monroe" wrote:

is there anyway to stop the auto format I need to enter
1-4-1
1-4-2
1-4-3 etc...
and the data showes up as dates in the cells I hate this auto function and I
would like to shut all auto features off they never help

1-4-1 is not a date how do I stop excel from changing whats enter
 

You can type an apostrophe (') before the text in the cell. This
causes Excel to treat it as literal text. The apostrophe will not
appear in the cell and it doesn't need to be taken into account in
other formulas that reference that cell.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional,
Excel, 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com



On Tue, 30 Mar 2010 07:14:02 -0700, Perry Monroe <Perry
wrote:

is there anyway to stop the auto format I need to enter
1-4-1
1-4-2
1-4-3 etc...
and the data showes up as dates in the cells I hate this auto function and I
would like to shut all auto features off they never help