Stop Excel from converting numbers to Dateformat

cplusHR

New Member
Joined
Mar 19, 2011
Messages
25
HI,

I'm opening a file in Excel, and it automaticaally changes a lot of the numbers to dates. How can I turn this off in the settings?
I want to stop it. It is not happening to all files that I open but to some of them.
 

Some videos you may like

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

cplusHR

New Member
Joined
Mar 19, 2011
Messages
25
I did find that, which makes those numbers as text I think, but is there any alternative in the options maybe to disable something. Cause I am talking about several worksheet and files that I need to edit with apostrophe in each cell.
 

cplusHR

New Member
Joined
Mar 19, 2011
Messages
25
As an update toward the issue or problem. I got to notice that those numbers are in formula and can not add apostrophe to those cells. Please I require a solution as the suggested solution does not address my problem.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,545
Messages
5,529,458
Members
409,879
Latest member
Aussie_Excel_Wanna_Be
Top