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 ?
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 ?
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" <[email protected]> wrote in message
news:[email protected]...
>
> 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks