Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbers change to a date format
I don't use Excel much, but when I enter a set of numbers in one cell, it
automatically changes to a date format (mm/dd/yyyy) as well as changing the numbers I entered when I hit return or go to the next cell. How do I disable this feature? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbers change to a date format
If the values you enter look like dates, then excel will treat them like dates.
You can stop this by making sure you're entering the values as text. You can Pre-Format the cells as Text (Format|cells|number tab in xl2003 menus) Then enter your value. Or you can prepend an apostrophe to your entry: '12/31 If you're really typing simple numbers (whole numbers or decimals), then this isn't the problem. Maybe you have the cell formatted as a date--or maybe you have an event macro that's firing that's doing the change. (But you'll have to supply examples of what's happening to get a better guess from me.) Gregg wrote: I don't use Excel much, but when I enter a set of numbers in one cell, it automatically changes to a date format (mm/dd/yyyy) as well as changing the numbers I entered when I hit return or go to the next cell. How do I disable this feature? Thanks. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbers change to a date format
Hi Dave. I enter in 799130, press return, and the numbers change to
12/9/4087. I do have a date in the cell directly above the cell in question. I guess Excel is just formating all the numbers in this column to dates, but I don't want that. How do I turn this formatting off? Thanks for your help. "Dave Peterson" wrote: If the values you enter look like dates, then excel will treat them like dates. You can stop this by making sure you're entering the values as text. You can Pre-Format the cells as Text (Format|cells|number tab in xl2003 menus) Then enter your value. Or you can prepend an apostrophe to your entry: '12/31 If you're really typing simple numbers (whole numbers or decimals), then this isn't the problem. Maybe you have the cell formatted as a date--or maybe you have an event macro that's firing that's doing the change. (But you'll have to supply examples of what's happening to get a better guess from me.) Gregg wrote: I don't use Excel much, but when I enter a set of numbers in one cell, it automatically changes to a date format (mm/dd/yyyy) as well as changing the numbers I entered when I hit return or go to the next cell. How do I disable this feature? Thanks. -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbers change to a date format
Hi Greg,
Select the cell or range of cells that you want to display as numbers, right click and select Format Cell Options and select General or Number Option. Hope that helps. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200908/1 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbers change to a date format
That is Excel helping you.
To turn off the automatic formatting go to ToolsOptionsEdit. Uncheck "extend data range formats and formulas" Gord Dibben MS Excel MVP On Sun, 16 Aug 2009 14:17:01 -0700, Gregg wrote: Hi Dave. I enter in 799130, press return, and the numbers change to 12/9/4087. I do have a date in the cell directly above the cell in question. I guess Excel is just formating all the numbers in this column to dates, but I don't want that. How do I turn this formatting off? Thanks for your help. "Dave Peterson" wrote: If the values you enter look like dates, then excel will treat them like dates. You can stop this by making sure you're entering the values as text. You can Pre-Format the cells as Text (Format|cells|number tab in xl2003 menus) Then enter your value. Or you can prepend an apostrophe to your entry: '12/31 If you're really typing simple numbers (whole numbers or decimals), then this isn't the problem. Maybe you have the cell formatted as a date--or maybe you have an event macro that's firing that's doing the change. (But you'll have to supply examples of what's happening to get a better guess from me.) Gregg wrote: I don't use Excel much, but when I enter a set of numbers in one cell, it automatically changes to a date format (mm/dd/yyyy) as well as changing the numbers I entered when I hit return or go to the next cell. How do I disable this feature? Thanks. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change Date Format to Specific Text Format When Copying | Excel Discussion (Misc queries) | |||
How do I change the date format in a pivot chart from numbers to a | Charts and Charting in Excel | |||
Use date modified to change format & create filter to track change | Excel Worksheet Functions | |||
excel numbers in general format i cant add cant change format | Excel Worksheet Functions | |||
How do i change numbers in text format to number format? | New Users to Excel |