| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stop cell auto format in Excel - SOLUTION!
I've seen many posts about folks wanting excel to not auto-format/parse
cells when loading from a CSV file. After struggling with the same problem myself and fiddling around for a bit I came up with this solution. Lets say that we want to put the value of "6/7" into a cell as it is. Naturally this would end up in our CSV like this... ....,6/7,... but Excel assumes that it is a date and converts it to 6 Sep. If however, we expressit as a formula and put it into the CSV like this... ....,="6/7",... then Excel correctly displays it as Text. =D |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| how do i stop the auto format on excel? | Excel Discussion (Misc queries) | |||
| any solution to the "too many cell formats error" in excel? | Excel Discussion (Misc queries) | |||
| Which Excel version has the slide transparency in format auto shap | Excel Discussion (Misc queries) | |||
| Excel - cell format switches to custom when switching language | Excel Discussion (Misc queries) | |||
Linear Mode
