| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
format cells in 30 different sheets
Hi,
I have a workbook containing 31 sheets (one for each day) named from 1 to 31. In a cell I want to display the date as "1-May-07", next sheet "2-May-07",... For now I have set up a custom format like 0"-May-07" so I only enter the numbers 1 to 31. Now, if i create the same workbook for another month, is there a quick way to turn "May" into "June" without changing the first cell format and copy it into each cell in each sheet? Thank you ! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| format 10 sheets on same file to look like first one | New Users to Excel | |||
| want format cells alignment not format cells font style | Excel Discussion (Misc queries) | |||
| Format all sheets in one Workbook | Excel Discussion (Misc queries) | |||
| Cells won't convert to number format, even after format/cells/num. | Excel Discussion (Misc queries) | |||
| Any way to force European format dates in sheets? | New Users to Excel | |||
Threaded Mode
