quick question
Thanks
"Gord Dibben" wrote:
Precede the 2-3 with an apsostrophe or pre-format the cells as Text before
entering 2-3
I find the apostrophe method is consistent and no chance of re-formatting and F2
+ ENTER which would change them into dates.
Gord Dibben MS Excel MVP
On Fri, 22 Feb 2008 19:58:01 -0800, Fady wrote:
Hello,
I would like to know guys how to stop excel from automatically converting my
numbers into dates. I type "2-3" in a cell, and whenever I hit enter or next,
I found it changed to 2-3 February. How can I stop that?
Thanks for yoru help
|