How do I convert a date to a general date in Excel?

Table of Contents Show

How do I convert a date in Excel to general without losing formatting?
How do I paste date as general in Excel?
How do I convert custom to general in Excel?
What is general date in Excel?

How do I convert a date in Excel to general without losing formatting?

Copy the dates that are in the cells that you want to convert. Copy the text and paste it into Notepad. Return to Excel and pick the cells into which you wish to paste the dates. Go to Home –> Number and pick the Text format with the cells chosen (from the drop down).

How do I paste date as general in Excel?

#3 Using Copy Paste Method.

First, copy the data. Then, open a notepad and paste it there. ... .

Now switch back to Excel and select the cells where you want to paste these dates..

Then, we must go to “Home” then “Number” with the cells selected and select the “Text” format (from the drop-down)..

Finally, paste the date as text..

How do I convert custom to general in Excel?

Reset a number to the General format.

Select the cell or range of cells that you want to reformat to the default number format. How to select a cell or a range. To select. Do this. A single cell. ... .

On the Home tab, click the Dialog Box Launcher. next to Number..

In the Category box, click General..

What is general date in Excel?

In a nutshell When you look at a date in Excel it's actually a regular number that has been formatted to look like a date. If you change the cell format to 'General' you'll see the underlying date serial number. The integer portion of the date serial number represents the day, and the decimal portion is the time.