View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
gobonniego gobonniego is offline
external usenet poster
 
Posts: 5
Default New question on formatting dates from 20090218

I have a column of dates typed as text like +20090218. I've searched this
board for ways to get them into a more readable format such as 2/18/2009.
I've followed everyone's suggestion (and done it on the column as text and as
numbers) and the best I can get is that it comes out as # signs. Usually to
me that means expand the column. When I do that, it's just number signs as
far as I can see.

So far, that's the only way it changes. Usually, it doesn't change at all.

More suggestions would be appreciated?

Bonnie