Format Time

M

MAX

I am working excel 2007 and I have a workbook which consists of 33 sheets.The
names of the first and last sheets are SAMPLE and SUMMARY respectively and in
between 01 to 31.
All I need is to arrange the time in the format of for example 04:31 from
cell A7 to A68 in sheets from 01 to 31. Is there a solution for this.

Thanks in advance.
 
A

Ashish Mathur

Hi,

Select A7:A68 on any one sheet and then Group all sheets from 01 to 31. Now
change the format as desired and the formatting on all grouped sheets should
change

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro for summarizing multiple sheets 1
Calculate End Date Using Start Date and No. of Days excluding specific days. 0
Code in certain sheets 1
Update cell value based on name and specific date 1
Sum value between two dates and copy to new cell 6
Insert code 2
Summing same cells in multiple worksheets 1
Lookup between two dates 3

Top