Turning off microsoft word auto dating
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.
what on earth is causing excel to handle this hours:minutes data as a date & hours data?
anyway, does that sound a bit illogical reasoning with excel?
Note: You can manually update the date by right-clicking the field and selecting “Update Field“.
I don't understand how to apply the code to my problem.
I have column A full of data from an imported source. I have to import large masses of hyphenated data for mapping purposes (usually designating particular coordinates), usually from files imported from my GPS.
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.