How to not auto date in excel
How to Disable a Date Autofill in Excel : Microsoft Excel Tips
Timecodes:
hi my name is Justin Conway I'm an excel
expert I'm going to show you how to
remove a date autofill in Microsoft
Excel there's an easy way to do this
hopefully you don't already have your
dates inputted or I'm sorry your numbers
inputted because the easiest way to do
it is to make sure that the cells don't
compute the the date to begin with and
to do that let's say you're going to
have in this example we have a new
worksheet we want the entire first
column to be numbers that are going to
look sort of like this let's have a 5 -
12 - something like that and that looks
like a date but maybe that's a some sort
of part number for you or something like
that in in Excel the way it's set up if
you hit enter now it would it would
normally turn to a date but the reason
it didn't is because if you go into if
you right click go to format cells you
can see that this the cell is actually
in the format of text and you can read
the description it's going to display
text exactly as it appears without
computing any of any functions if we
perform this in another cell which
hasn't had that applied to it and hit
enter you can see that it automatically
defaults to the date problem is once
this occurs if you try to go back by
going into format cells and select text
it will not display the information as
it originally appeared it sort of all
changed in the calculation process so
the key to this is making sure that the
cell to begin with is in text format so
once again we'll do that in the cell
right here we'll go to right click
format cells text okay now when we input
that same data and enter it maintains
its actual format without being
converted to a date and that's how to
keep the information the numbers from
converting into a date in Microsoft
Excel my name is Justin Conway I hope
you enjoyed
Related queries:
how to stop auto date in excel
how to avoid automatic date in excel
how to not automatically change to date in excel
how to set auto date in excel
how to auto date in excel
how to turn off auto date in excel
how to auto date in excel formula
how to set up automatic date in excel
