Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I stop Excel auto formatting the text 3-4 as 04 Apr?
I run a web query that imports soccer results to Excel. Unfortunately the web
site formats the result as 3-1 for example. This text is automatically converted to 03 Jan by Excel. I can't seem to stop this happening, even if I explicitly set the cell format to text. Doing so just converts the contents, which were a date, to the internal date number and if I re load the data it reverts to 03 Jan again. Does anyone know how I might get excel to leave the format of the cells alone? thanks ahughf |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Putting Excel formatting and/or formulas into CSV file | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Autofitting a row | Excel Discussion (Misc queries) | |||
How do I convert a number formated as a date to text in Excel? | Excel Discussion (Misc queries) | |||
Auto date changing in Excel is maddening | Charts and Charting in Excel |