| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Some Cells display text others dates in the same column
I imported a .csv file into Excel. One column contains the SKU # of a
product. All my SKU's are formatted as x-xxxx. However some of the cells in the column display the SKU as it should, but many (45 out of 170) are displayed as a date format mmm-yy. Each one of the 45 is different. The cells in question show up as "custom" and when I try to change it to "text" I get a completey different number than the SKU I need. Somebody please help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display Text in Formula Bar for certain cells | Excel Worksheet Functions | |||
| Display text from a single cell in a column range | Excel Discussion (Misc queries) | |||
| Text Will Not Display In Cells | Excel Discussion (Misc queries) | |||
| Display cells(text) in one column based on cells which are present inother column | Excel Discussion (Misc queries) | |||
| Grid column display text trimming | Excel Discussion (Misc queries) | |||
Threaded Mode
