When I type data ranging from 3-6 it automatically changes this to the date
of March 6 and that's not what I want. How do I stop this insanity?!
When I type data ranging from 3-6 it automatically changes this to the date
of March 6 and that's not what I want. How do I stop this insanity?!
either preformat the cell as Text (so that XL doesn't try to parse it),
or prefix the data with an apostrophe to indicate to the parser that
what follows is text:
'3-6
In article <0DE36F37-AC2F-4B67-9D08-5D8926A9EACF@microsoft.com>,
"Sara" <Sara@discussions.microsoft.com> wrote:
> When I type data ranging from 3-6 it automatically changes this to the date
> of March 6 and that's not what I want. How do I stop this insanity?!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks