Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Entering combos without converting it to dates?
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?! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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?! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Entering combos without converting it to dates?
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: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=517288 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
prevent converting numbers with hyphens to dates | Excel Discussion (Misc queries) | |||
imported text data converting to dates | Excel Discussion (Misc queries) | |||
Entering DATEs in EXCEL should not require use of "/" slashes. | Excel Discussion (Misc queries) | |||
Excel should have a formula for Converting Julian Dates | Excel Worksheet Functions | |||
Entering dates in Excel 2002 | Excel Discussion (Misc queries) |