Excel Changes random numbers to date

Keep in mind that "4-1957" is not a number.
I'm no fan of Excel's "helpful" features like auto-date conversion,
auto-hyperlinking email addresses, etc. , but in this case you should
keep in mind that a formula isn't a formula unless it begins with an "="
(or, for purists, a "-" or "+" will work too)


In article <C52B71FD.45804%onlygeneraltaz1@com.cast.net>,
CyberTaz <onlygeneraltaz1 RemoveThis @com.cast.net> wrote:

> There are at least 2 options;
>
> 1- type an apostrophe before the digits so they will be treated as a text
> string rather than being interpreted as a Date (the ' won't display), or
>
> 2- pre-format the cells as Text
>
> HTH |:>)
> Bob Jones
> [MVP] Office:Mac
>
>
> On 10/27/08 1:07 PM, in article
> 90234B32-8FBC-42A5-BB32-8DBC35E68B53 RemoveThis @microsoft.com, "gueyo"
> <gueyo RemoveThis @discussions.microsoft.com> wrote:
>
> > Hi
> > Can anyone tell me how to stop excel from changing random numbers into
> > dates? example 4-1957 change to April 1957 this is driving me nuts.

--
Team EM to the rescue! http://www.team-em.com