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