Entering combos without converting it to dates?

G

Guest

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?!
 
G

Guest

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.
 
D

Dav

1) format the cells to text fbefore entering the combos

or

2) Enter the combo's with a leading '

Regards

Dav
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I stop auto converting Text(Inventory#) to Dates 1
entering data using - between numbers without converting to date 8
quick question 7
dates question 2
Dates in Excel 2
Turning off the month function 3
prevent Excel from EVER automatically converting numbers to dates 1
converting dates from file 3

Top