Hi Phil,

Format the entire column manually, choose Format, Cells, Number tab, Custom
and enter #-#### in the Type box and hit OK.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Ragtime Phil" wrote:

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.