I want the cell to be "3 - 5" but it auto changes it to "5-Mar".

How do I stop that from happening besides using '3-5 ?


--
KH_GS
------------------------------------------------------------------------
KH_GS's Profile: http://www.excelforum.com/member.php...o&userid=32920
View this thread: http://www.excelforum.com/showthread...hreadid=540511

Only way is to either precede each entry with an apostrophe ' (it's not
visible in the cell) or to pre-format as text

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"KH_GS" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> I want the cell to be "3 - 5" but it auto changes it to "5-Mar".
>
> How do I stop that from happening besides using '3-5 ?
>
>
> --
> KH_GS
> ------------------------------------------------------------------------
> KH_GS's Profile:
> http://www.excelforum.com/member.php...o&userid=32920
> View this thread: http://www.excelforum.com/showthread...hreadid=540511
>

Preformat the cell as Text, then type your entry.

KH_GS wrote:
>
> I want the cell to be "3 - 5" but it auto changes it to "5-Mar".
>
> How do I stop that from happening besides using '3-5 ?
>
> --
> KH_GS
> ------------------------------------------------------------------------
> KH_GS's Profile: http://www.excelforum.com/member.php...o&userid=32920
> View this thread: http://www.excelforum.com/showthread...hreadid=540511

--

Dave Peterson