Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
This is one way to do it.
Say you want to write Jan to Dec in Cells A1 to A12. Enter the following formulas in A1 to A12 1 =+A1+31 =+A2+31 =+A3+31 =+A4+31 =+A5+31 =+A6+31 =+A7+31 =+A8+31 =+A9+31 =+A10+31 =+A11+31 Now set the format of these cells to Month. To do this Select A1 to A12.Format CellsCustom, In the "Type:" box type MMMM and click OK. With this you have only changed the format, the actual data is not the name of the months. To convert this into text copy : paste it in note pad or word and then copy: paste it back to excel. The easiest way : You write all the 12 Months once. :) ;) Thanks Karthik Bhat Bangalore |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel won't fill formulas | Excel Worksheet Functions | |||
fill out a scanned form in excel spreadsheet ? | Excel Discussion (Misc queries) | |||
autoshape fill problems in Excel 2003 | Excel Discussion (Misc queries) | |||
How do I fill an Excel template from a file | Excel Worksheet Functions | |||
Identifying the Active Fill Color | Excel Discussion (Misc queries) |