Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem entering dashes in certain spots
I have a problem where sometimes when I try to enter a number in the format:
1-4-1 in a cell, it automatically enters different number such as 35639. I cannot find any hidden formulas, or conditions, and it doesn't happen in every cell.Anyone have any ideas about what could be causing this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem entering dashes in certain spots
Excel thinks you are entering dates and is converting to the serial number
for that date. 35639 is 7/28/1997 for example. 36895 would display for a cell where you typed 1-4-1 and excel coverted to a date. Format the cells as text before you enter, to stop it from happening or you can begin the cell entry with an apostrophe: '1-4-1 which is just another way to format a cell as text. The apostrophe will not display in the cell. "WorkingHardly" wrote: I have a problem where sometimes when I try to enter a number in the format: 1-4-1 in a cell, it automatically enters different number such as 35639. I cannot find any hidden formulas, or conditions, and it doesn't happen in every cell.Anyone have any ideas about what could be causing this? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem entering dashes in certain spots
Excel is...ahem..."helping". It assumes you intended to enter a date, so it
converts your date-like input to an Excel date-serial number. To Excel, each date is represented by the number of days the date is after 31-DEC-1899. For example: 01-JAN-1900 is date-serial 1 11-MAR-2008 is date-serial 39,518 To avoid the conversion: 1) Enter an apostrophe (') before the entered value: '1-4-1 or 2) Format the input cells as TEXT From the Excel Main Menu: <format<cells<number tab Category: Text Does that help? Post back if you have more questions. -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "WorkingHardly" wrote in message ... I have a problem where sometimes when I try to enter a number in the format: 1-4-1 in a cell, it automatically enters different number such as 35639. I cannot find any hidden formulas, or conditions, and it doesn't happen in every cell.Anyone have any ideas about what could be causing this? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem entering dashes in certain spots
Excel has translated your 1-4-1 to a date of 1/4/2001 (which it stores as
36982 or 36895, depending on whether it interprets it as 1st April or 4th January). If you want to keep the data as 1-4-1, either format the cell as text before you type the data in, or prefix the data with an apostrophe. -- David Biddulph "WorkingHardly" wrote in message ... I have a problem where sometimes when I try to enter a number in the format: 1-4-1 in a cell, it automatically enters different number such as 35639. I cannot find any hidden formulas, or conditions, and it doesn't happen in every cell.Anyone have any ideas about what could be causing this? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem entering dashes in certain spots
That worked guys, thanks for all your help on this. I cannot tell you how
annoying that was. Thanks! "WorkingHardly" wrote: I have a problem where sometimes when I try to enter a number in the format: 1-4-1 in a cell, it automatically enters different number such as 35639. I cannot find any hidden formulas, or conditions, and it doesn't happen in every cell.Anyone have any ideas about what could be causing this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically put AutoShape in certain spots | Excel Discussion (Misc queries) | |||
Conditional Formatting and Entering Dates with out dashes | Excel Discussion (Misc queries) | |||
Problem entering amounts. | Excel Discussion (Misc queries) | |||
what are the blue spots that appear and disappear? | Excel Discussion (Misc queries) | |||
I need to add mew rows for different spots. | Excel Discussion (Misc queries) |