00:00hi everyone to remove date formatting in microsoft excel and convert the cell back to the standard
00:06text or a general number you need to follow these tabs so first you need to select the cell or
00:13you
00:13can select the range of cells you want to change and then go to the home tab on the ribbon
00:21and
00:21in the found group you need to click on this small arrow and then click on the number tab
00:28and now you can select the journal to display it as a serial number or you can select the
00:36text to display it as a plain tag click ok to apply so in the second method if you want
00:44to reset the
00:45cell completely removing colors borders and date format for this you need to select the cell or you
00:52can select the range as well then go to the home tab and in the editing group you need to
00:59click
00:59on this small arrow click on this clear and click on the clear format in the third method if you
01:06want
01:06to keep the date visible but ensure excel tree reads add purely as plain text so for this you need
01:14to
01:14put an apostrophe before the date so for this you need to press the f2 and put a apostrophe before
01:22the
01:22date like this one let me open my on screen keyboard i'll do it again so press the f2 and
01:33here is the apostrophe you just need to click on before the date like this one
01:41so this is pretty simple and easy i hope you understand how you can remove date format in
01:45excel cell if you think this video is helpful please support my channel thanks for watching
Comments