Board index Computer & Internet Office & Other Software How to stop Excel auto modification of number into a date

How to stop Excel auto modification of number into a date

Post your problems of office and other software


Posts: 72
When I do some data entry in the Excel, the program helps me to turn some numbers into data. I think it has changed the format of cell. But now I want to stop such modifications and set the format of cell as general. I want to see what I type in the cell. How can I do that?
Thanks in advance!


Posts: 84
I’m clear about your question. And you want Text of all content. So when you set the format of the cell as Text, you can get what you type in. For example, you will have a zero in front when you type in a zero leading number.

You can try the following the steps:
1. Press Ctrl+1 to recall the Formatting window
2. Click Number, and then select Text

This helps most of the time. Hope you can solve the problem!


Return to Office & Other Software

cron