how to create predefined series of texts like weekdays,months and

S

Suleman Peerzade

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
 
G

Gord Dibben

Weekdays, months should be default in Tools>Options>Custom 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
 
Top