Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date format default problem
If I type a serial 02/2668 into Excel it gets confused and thinks it is
February in the year 2668. This then confuses me. Is there a way of straightening the matter. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date format default problem
I think you could either:
EditFormat \Category: TEXT So anything you type in the cell will be treated as text. OR Type an apostrophe before the number, forcing Excel to treat the input as text. Example: A1: '02/2668 Does that help? *********** Regards, Ron "Hood" wrote: If I type a serial 02/2668 into Excel it gets confused and thinks it is February in the year 2668. This then confuses me. Is there a way of straightening the matter. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date format default problem
On Mon, 21 Nov 2005 07:26:06 -0800, "Hood"
wrote: If I type a serial 02/2668 into Excel it gets confused and thinks it is February in the year 2668. This then confuses me. Is there a way of straightening the matter. It depends on what you what to do. If you want to enter it as a string, then pre-format the cell as text; or precede your entry with an apostrophe (single quote) or a <space. If you want to enter it as a fraction, then enter it as 0 2/2668 --ron |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date format default problem
preformat the cell as text (format|Cells|number tab|Text)
or prefix your entry with an apostrophe: '02/2668 Hood wrote: If I type a serial 02/2668 into Excel it gets confused and thinks it is February in the year 2668. This then confuses me. Is there a way of straightening the matter. -- Dave Peterson |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date format default problem
Correction of my previous post.
That should be: EditFormatNumber \Category: TEXT Does that help? *********** Regards, Ron "Ron Coderre" wrote: I think you could either: EditFormat \Category: TEXT So anything you type in the cell will be treated as text. OR Type an apostrophe before the number, forcing Excel to treat the input as text. Example: A1: '02/2668 Does that help? *********** Regards, Ron "Hood" wrote: If I type a serial 02/2668 into Excel it gets confused and thinks it is February in the year 2668. This then confuses me. Is there a way of straightening the matter. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Yikes....my brain stopped working
Wow....I think I might have forgotten everything I knew about Excel!
EditFORMAT????.....NO! FormatCellsNumber....Yes. (sheesh!) *********** Regards, Ron "Ron Coderre" wrote: Correction of my previous post. That should be: EditFormatNumber \Category: TEXT Does that help? *********** Regards, Ron "Ron Coderre" wrote: I think you could either: EditFormat \Category: TEXT So anything you type in the cell will be treated as text. OR Type an apostrophe before the number, forcing Excel to treat the input as text. Example: A1: '02/2668 Does that help? *********** Regards, Ron "Hood" wrote: If I type a serial 02/2668 into Excel it gets confused and thinks it is February in the year 2668. This then confuses me. Is there a way of straightening the matter. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MS Query Date Format | Excel Discussion (Misc queries) | |||
Customized Date Format | Excel Worksheet Functions | |||
NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
format date in excel | Excel Discussion (Misc queries) | |||
imported impromtu report date issue - fix by format or formula | Excel Discussion (Misc queries) |