Turning off microsoft word auto dating
as if the information is a date in -- 05 september 2003. whatever it is i would like to turn it off so that excel never formats any data until i tell it to. bruno hello again, formatting the cells beforehand is one way of approaching the problem, but it often doesn't help.
hello, i often have the most annoying problem with excel.it automatically decides how to format specific data. i've imported a text file with some timing information in minutes:seconds.every time excel automatically makes it hours:minutes. well, when i import it, the data is now conveted to " ".Stop auto formatting number by adding a space or apostrophe Stop auto formatting number by formatting as Text Convert text date/number string to standard date If you only have a few numbers to enter, you can stop Excel from changing them into dates by entering a space or apostrophe.Before you enter the number data, type a space or apostrophe ‘ into the cell then following the number data, press Enter.In thses case, you may want to convert thses nonstandard dates to the standard date formatting Convert to Date. After applying the Convert to Date, you can see all the nonstandard dates have been converted to the standared dates in the Convert to Date dialog, and just click OK to exist the dialog. If you want to have a free trial of the Convert to Date function, please go tofree download Kutools for Excel first, and then go to apply the operation according above steps.
If you have a template or other type of document that regularly requires the date to be updated, you can make Microsoft Word 2016 or 2013 display a date that automatically updates.
If you format back to text you may end up with a number that was not what you entered.
The following VBA function should convert the altered value back to it's original.
bruno Excel interprets as 28 hours and 17 minutes.
As a date serial number this is 1.178472 - that's one day and 4hours 17 minutes. You can avoid the autoformatting by clicking the column(s) and checking Text as the Column data format at Step 3 of the Text Import Wizard. The way that a time or date is displayed on a worksheet depends on the number format applied to the cell.
In Excel, when you type a string number like “2014-6-1” or “1/2” into a cell, it will auto format this number to date “6/1/2014” or “2-Jan”.