Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
How do I stop auto converting Text(Inventory#) to Dates
I there a way to Stop Excel from auto converting Text (Inventory Part
Numbers) to Dates. I can't find an Option to turn this off for this project. |
#2
|
|||
|
|||
If a cell is formatted as General and you put something into it that looks
like a date, Excel will try to "help" you by converting it into a date. Solution: Format the cell(s) as Text prior to entering data into them and Excel will leave them alone. Good Luck -- Gary's Student "DavidB" wrote: I there a way to Stop Excel from auto converting Text (Inventory Part Numbers) to Dates. I can't find an Option to turn this off for this project. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can't stop auto fomatting - help | Excel Discussion (Misc queries) | |||
Stop numbers converting to dates. | Excel Worksheet Functions | |||
Stop Excel from converting text labels in CSV files to Values | Excel Discussion (Misc queries) | |||
Can't stop time duration [hh]:mm:ss converting to time of day | Excel Discussion (Misc queries) | |||
How Do I stop Auto Unhiding Rows? | Excel Worksheet Functions |