| 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 | |||
Linear Mode
