software

I am trying to enter locker combinations in an excel spreadsheet. However,
excel keeps converting these automatically to calendar dates. How do I turn
this function off?!

Hi

If you format the column as Text first, Excel will leave the figures as they
are. An alternative is to put an apostrophe ' before each cell entry.

Andy.

quot;pkroper22quot; gt; wrote in message
...
gt;I am trying to enter locker combinations in an excel spreadsheet. However,
gt; excel keeps converting these automatically to calendar dates. How do I
gt; turn
gt; this function off?!

1) format the cells to text fbefore entering the combos

or

2) Enter the combo's with a leading '

Regards

Dav--
Dav
------------------------------------------------------------------------
Dav's Profile: www.excelforum.com/member.php...oamp;userid=27107
View this thread: www.excelforum.com/showthread...hreadid=517288