Date format default problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hood - 21 Nov 2005 15:26 GMT

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 to this Message

Ron Coderre - 21 Nov 2005 15:37 GMT

I think you could either:

Edit>Format
\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

> 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 to this Message

Ron Coderre - 21 Nov 2005 15:42 GMT

Correction of my previous post.

That should be:
Edit>Format>Number
\Category: TEXT

Does that help?

***********
Regards,
Ron

> I think you could either:
>
[quoted text clipped - 18 lines]
> > February in the year 2668. This then confuses me. Is there a way of
> > straightening the matter.

Reply to this Message

Ron Coderre - 21 Nov 2005 15:52 GMT

Wow....I think I might have forgotten everything I knew about Excel!

Edit>FORMAT????.....NO!

Format>Cells>Number....Yes. (sheesh!)

***********
Regards,
Ron

> Correction of my previous post.
>
[quoted text clipped - 30 lines]
> > > February in the year 2668. This then confuses me. Is there a way of
> > > straightening the matter.

Reply to this Message

Ron Rosenfeld - 21 Nov 2005 15:38 GMT

>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

Reply to this Message

Dave Peterson - 21 Nov 2005 15:39 GMT

preformat the cell as text (format|Cells|number tab|Text)

or prefix your entry with an apostrophe:

'02/2668

> 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.

Signature

Dave Peterson

Reply to this Message