How to not have dates in excel
How to Stop Numbers Converting into Dates in MS Excel
Timecodes:
hey guys hope you'll find their dmg to
get back with Excel today I'll show you
how to stop numbering converting into
dates in Microsoft Excel so the easy
thing is I'll show you when I'm trappin
like 5/3 it will convert like 3 min as
you can see here or 6-3 it will convert
other month so I don't want to this
format I want to just simply my data
will like 5/3 so how to do this I show
you easy method so select your area
which you want to convert don't want to
convert your number into date like this
I want to sell this entire column and
after select simply go to your home and
here in the journal extensive and
selected text ok that's it and not try
5/3 boom that's it
and 7-8 so there is no converting
numbers in two days if I try to type the
same thing in the next column myself
let's see what happened a solid look at
that it's converting numbering into tape
so the easy thing is just select your
area like this we say I want two numbers
and simply select text boom that's it no
time so this is the way to stop
converting number into dates in
Microsoft Excel and this will work all
the version of Microsoft Excel like say
1 mm or chain 13 or 16 so I hope it will
help you and if you have any better area
you can share in comments thank for
watching seen next video please like
share and subscribe thank you very much
Related queries:
how to not auto date in excel
how to not format date in excel
how to skip dates in excel
how to get the date only in excel
how to not get date in excel
