1-4-1 is not a date how do I stop excel from changing whats enter
in [Functions]
|
Prev: How do I set up a formula to add column a if column b = cell c
Next: Unique Rank with Duplicate Entries
From: Perry Monroe Perry on 30 Mar 2010 10:14 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
From: Fred Smith on 30 Mar 2010 10:26 Precede your entry with an apostrophe ('). Regards, Fred "Perry Monroe" <Perry Monroe(a)discussions.microsoft.com> wrote in message news:BE637CE6-DFCF-4F61-BA7E-EA4598401524(a)microsoft.com... > 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
From: Bernard Liengme on 30 Mar 2010 10:29 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 Monroe(a)discussions.microsoft.com> wrote in message news:BE637CE6-DFCF-4F61-BA7E-EA4598401524(a)microsoft.com... > 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
From: RonaldoOneNil on 30 Mar 2010 10:37 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
From: Chip Pearson on 30 Mar 2010 10:47
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 Monroe(a)discussions.microsoft.com> 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 |