View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Eva Eva is offline
external usenet poster
 
Posts: 197
Default how do i split a cell that contains dd/mm/yy into a 3 separate cel

I have a column that contains a list of paid invoices and the payment date is
showing as dd/mm/yy. I need to do a pivot by month. How do I change my cell
from the current format so the month is shown in one cell and the year in the
next cell?