Thread: Formatting Date
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Question Boy Question Boy is offline
external usenet poster
 
Posts: 25
Default Formatting Date

I have a column which contains dates

2008-Jan-10

I have tried changing the cell format, but it has no effect. I have tried
using the Text(..,"yyyy-m-d"), but it has not effect. How can I change the
format so it is formatted like yyyy-m-d?

Thank you

QB