| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbers change in cell even when formatted as text
Hi again,
Am Tue, 28 Oct 2014 08:32:37 -0700 (PDT) schrieb michaelberrier: This originally started when I imported a workbook of survey data with a column representing years of experience. Some of the options were "1-3", 3-5", etc. For every one of those that could be translated into a date (1/3/2014), the spreadsheet automatically did that. Is there a way to stop Excel from doing that so I don't have to make this fix in the first place? format the expected column as text before importing the data. Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| numbers formatted as text | Excel Discussion (Misc queries) | |||
| a code to trace pure numbers formatted as Text | Excel Programming | |||
| Pivot Table keep apart cells text that I've formatted as numbers | Excel Worksheet Functions | |||
| Converting numbers formatted as text to numbers | Excel Discussion (Misc queries) | |||
| Converting 'General' formatted cells to Text formatted cell using. | Excel Worksheet Functions | |||
Threaded Mode
