How to Keep a Date Format When Typing or Pasting in Excel
Question details
The user wants to maintain a specific or custom date format when typing new dates or pasting data from other sources into Excel.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Pasting data into a spreadsheet or manually typing date values into cells.
- Observed behavior
- Excel changes the preferred date format to the source formatting or displays dates as serial numbers (e.g., 44000) instead of actual dates.
Identify the destination cells where you plan to enter or paste the dates, and decide on the exact date format you want to preserve (e.g., MM/DD/YYYY). Ensure you have copied your source data before beginning the paste process.
Use the "Match Destination Formatting" Paste Option
This method ensures that the pasted data adopts the date format already set in your destination cells, rather than bringing over unwanted formatting from the source.
Excel's default paste behavior includes copying both the data and the source formatting. Using the Match Destination Formatting option forces Excel to keep the destination cell's format properties.
Select the column or cells where you want to paste the dates. Right-click and choose "Format Cells," then select your desired "Date" format or set a "Custom" date format.
Copy your source data. Click on the first destination cell, go to the "Home" tab, click the arrow below the "Paste" button, and select "Match Destination Formatting" (represented by a clipboard icon with an arrow).
Alternatively, paste the data normally by pressing Ctrl+V. A small "Paste Options" floating button will appear next to the pasted data. Click it and select "Match Destination Formatting".

Format Cells as Text to Prevent Auto-Formatting
Use this method if you are typing dates in a very specific custom way and want to prevent Excel from automatically reinterpreting them as different date formats or serial numbers.
Easily Manage Date Formats with WPS Spreadsheet
WPS Spreadsheet offers an intuitive interface to handle data formatting, preventing unwanted changes when you paste or type dates. It provides seamless handling of custom date formats, advanced paste options, and full compatibility with Microsoft Excel files.
- 1. Format the destination column: Select the target column in WPS Spreadsheet, right-click, select "Format Cells," and choose your preferred Date format.
- 2. Copy the source data: Select the dates you want to transfer from your source document and press Ctrl+C to copy them.
- 3. Paste as unformatted text: Right-click the destination cell, go to "Paste Special," and select "Match Destination Formatting" or "Unformatted Text" to keep your preset date format intact.

Frequently Asked Questions
Why does Excel show a number like 44000 instead of a date?
Dates in Excel are stored as sequential serial numbers so they can be used in calculations (e.g., January 1, 1900 is serial number 1). A number like 44000 simply means the cell is missing the Date format. Changing the cell format to "Date" will display it correctly.
How can I set a custom date format for my entire column?
Click the column letter at the top to select the whole column. Right-click and choose "Format Cells". Go to the "Number" tab, select "Custom" from the category list, and type your desired format (like DD-MMM-YYYY) in the "Type" box.
What is the difference between "General" and "Text" formats when typing dates?
In "General" format, Excel tries to guess what you are typing. If it looks like a date, Excel converts it to a date serial number and applies a default date format. In "Text" format, Excel disables this automatic conversion and treats your input exactly as a string of characters.
Can I use a keyboard shortcut to match destination formatting?
Yes. After pasting the data with Ctrl+V, you can press the Ctrl key on your keyboard to open the Paste Options menu, then press M to select "Match Destination Formatting".




