View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Entering combos without converting it to dates?

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.

"pkroper22" wrote in message
...
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?!