| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to create predefined series of texts like weekdays,months and
please help i want to create the above in excel
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to create predefined series of texts like weekdays,months and
Hi,
Use excel date and time formulas for this. For eg today's date in cell A2 of sheet 1 =TODAY() will return the current date accordingly you can use other functions. -- _______________________ Click "Yes" button if it helps ________ Thanks Suleman Peerzade "ash" wrote: please help i want to create the above in excel |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to create predefined series of texts like weekdays,months and
Weekdays, months should be default in ToolsOptionsCustom Lists
But if not, create a new list by clicking on New and entering your comma-delimited list then hit Add button. Gord Dibben MS Excel MVP On Sat, 17 Jan 2009 00:21:01 -0800, ash wrote: please help i want to create the above in excel |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| fill series by weekdays in XL 2007 | Excel Discussion (Misc queries) | |||
| How do I create a dynamic series of months in excel? | Excel Worksheet Functions | |||
| How do I create a calendar with the months I need? | Excel Discussion (Misc queries) | |||
| How to input Jan & have a series filled in for the rest of months | Excel Worksheet Functions | |||
| How do I create a range of months in Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
