Date values appear as number even after formatting

  • Thread starter Thread starter Chuck W
  • Start date Start date
C

Chuck W

Hi,

I have a pivot table where cells A12 to A24 are Dates. They appear as
12/1/2008, 1/1/2009 etc. I have another cells (F10) in which I am attempting
to reference two cell ranges. The formula I have in F10 is =A19 & "to" & A17.
I want cell F10 to read 10/1/08 to 2/1/09. The date values would change in
the future when I refreshed the pivot table. However, the date values are
appearing as numbers. The formula comes out as 39692 to 39845. I went to
format this box as a Date but it is already a date value. Can someone help?

Thanks,

Chuck
 
Chuck,
Instead of A19
put
TEXT(A19,"m/d/yy")
in your formula.
Hope that helps,
Barbara
 
Back
Top