Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Stop Excel 2007 auto format to date
Hi there
I hope someone can solve this issue. I regularly get datasets with columns of data similar to the following 1/10 red rep1 2/11 rep rep2 These are sample names which I use "text to Columns" to split by the space resulting in 3 columns. Excel automatically assumes the 1/10 is a date. I have read all threads where users are advised to pre format the cell as text which works well when inputting data; this does not however work when splitting a cell into more columns. There are work abounds which I use but I love to know if there's an option to turn this infuriating function off for good. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I stop Excel from auto-inserting a date? | Excel Discussion (Misc queries) | |||
How to stop back up files from being auto created in Excel 2007 | Excel Discussion (Misc queries) | |||
Stop cell auto format in Excel - SOLUTION! | Excel Discussion (Misc queries) | |||
how do i stop the auto format on excel? | Excel Discussion (Misc queries) | |||
Excel Date Format - Stop? | Excel Worksheet Functions |