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