I am typing a single digit number in a cell, and when I enter it, it
automatically becomes a date. All I want to enter is a single digit.
I am typing a single digit number in a cell, and when I enter it, it
automatically becomes a date. All I want to enter is a single digit.
Edit - clear - format
"Ed" <[email protected]> wrote in message
news:[email protected]...
>I am typing a single digit number in a cell, and when I enter it, it
> automatically becomes a date. All I want to enter is a single digit.
With the cursor in that cell, click Format, Cells (in the menu) and look at
the number formatting. That cell is behaving as if it thinks you want a date
there. Choose a different number format.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks