View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Formatting Problem

hi
preformat the column as text.

regards
FSt1

"MET" wrote:

I want to format a column to not automatically convert the numbers I'm
entering into a date. I highlight the column and click on "format cells".
On the Number tab I click on General which states "General format cells have
no specific number format" and then I click on OK. This is what I think I
want. But when I enter "12-14" in one of the cells, it converts it to
"14-Dec".