Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I stop excel changing the font size when I enter a url? | Excel Discussion (Misc queries) | |||
how can I stop Excel Advancing the year by 1 when I enter a date? | Excel Discussion (Misc queries) | |||
How do I stop excel automatically changing my date to 2005? | Excel Discussion (Misc queries) | |||
How do I stop Excel from changing numbers into a date? | Excel Discussion (Misc queries) | |||
stop changing data to date | New Users to Excel |