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.
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.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks