How do I get monthly data in the data area to remain in order

  • Thread starter Thread starter Guest
  • Start date Start date
It sounds like your months might be entered as text. Try entering the months
as dates and then formatting them in the "Format Cells" dialog box. For
example, enter:

01/01/2007
02/01/2007
03/01/2007

Then go to the Format Cells dialog box and reformat the dates as you want
them to look.
 
Thanks John!! It worked. Also, before receiving yr reply, I tried
protecting the sheet of original data, which worked as well.

Thanks again
 
Back
Top