Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel worksheet
Jn my excel worksheet, there are a few boxes, that change the data I
enter...For example row F, line 155, I type in the number 46....push the tab for the next box and the 46 turns into 1/06/1900...What would cause this and how do I change it? Thanx.... |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel worksheet
The cell is formatted as a date. Chenge it to general.
"fubar1" wrote: Jn my excel worksheet, there are a few boxes, that change the data I enter...For example row F, line 155, I type in the number 46....push the tab for the next box and the 46 turns into 1/06/1900...What would cause this and how do I change it? Thanx.... |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel worksheet
But 46 is 15/2/2000, so there may be some further confusion.
-- David Biddulph "Mike" wrote in message ... The cell is formatted as a date. Chenge it to general. "fubar1" wrote: Jn my excel worksheet, there are a few boxes, that change the data I enter...For example row F, line 155, I type in the number 46....push the tab for the next box and the 46 turns into 1/06/1900...What would cause this and how do I change it? Thanx.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
When I open a an existing excel worksheet, it duplicates itself a. | Excel Discussion (Misc queries) | |||
Excel 2007 Worksheet | Excel Discussion (Misc queries) | |||
Prevent changing size when copy&paste into another Excel Worksheet | Excel Worksheet Functions | |||
Excel worksheet linking | Excel Worksheet Functions |