Home > Mobile Tutorial > iPhone > Excel keeps changing numbers: How to fix it

Excel keeps changing numbers: How to fix it

PHPz
Release: 2024-04-01 10:21:33
forward
887 people have browsed it

Excel has this feature, which can automatically convert numbers in cells to specific dates. However, if Excel starts changing numbers to date format, this helpful feature can quickly become the cause of your headache! This problem may affect an entire row or entire column. No matter what situation you're facing, these tips and tricks should help you solve your problem.

Fix 1 – Format cells as text

You must format cells in your Excel spreadsheet as text. This will definitely solve the problem.

Step 1 – Open the Excel workbook you are experiencing problems with.

Step 2 – Then, select the cell in which you have the problem.

Step 3 – Next, immediately right-click on the selected cell and select the “Format Cells” option.

Excel keeps changing numbers: How to fix it

Step 4 – You must appear in the “Number” section.

Step 5 – Set the “Category:” in the list to “Text”.

Step 6 – Click “OK”.

Excel keeps changing numbers: How to fix it

This way, you can specify these cells to contain text only. After making these changes, there won't be any issues regarding the cells changing dates automatically.

Fix 2 – Paste text as special text

If you want to paste text from other dataset/workbook or any other source, then Paste Special option should be preferred.

Step 1 – When pasting the copied content, find the paste settings.

Step 2 – Click on “Paste” and turn on the “Paste Selection” option.

Excel keeps changing numbers: How to fix it

Step 3 – When this will load the default “Select to Paste” page, select the “Text” or “Value” option from there.

Step 4 – Click OK.

Excel keeps changing numbers: How to fix it

Inserting the value in the cell in the specified way should help you solve the problem.

These numbers will no longer be automatically converted to date format.

Fix 3 – Placing apostrophes

There is also a shortcut fix. Placing an aphostrophe before the value in the cell should fix it.

Step 1 – In the workbook, go to and select the cell.

Step 2 – Next, place this ‘in the cell.

Step 3 – Paste the date after the apostrophe.

Excel keeps changing numbers: How to fix it

Because Excel does not read cell data as date input, it does not automatically convert it to a date.

That's it! Data you put after an apostrophe is not automatically converted to date format.

Hope these solutions can help you solve your problem.

The above is the detailed content of Excel keeps changing numbers: How to fix it. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:yundongfang.com
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template