Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need to insert columns in a specific place in a worksheet ...lets say
after column X and I need to have months and year going from 01/02 to 12/07 inserted. Also while the cells have a numeric value the user can only see J F M A and so on. Can you please help me --- Message posted from http://www.ExcelForum.com/ |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Kaj
Go to column Y and enter "01/02", then in col Z enter "02/02" (feb?). Select both together and then drag th combination to the right until you get to the date you need. you should then select them all and format/cells date good luc ----- kaj1104 wrote: ---- I need to insert columns in a specific place in a worksheet ...lets sa after column X and I need to have months and year going from 01/02 t 12/07 inserted. Also while the cells have a numeric value the user ca only see J F M A and so on. Can you please help m -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Convert date from Gregorian Calendar to Hijri Calendar | Excel Discussion (Misc queries) | |||
find free sharware to include calendar pop or use calendar in cell | Excel Discussion (Misc queries) | |||
how do i export excel calendar info to outlook calendar? | Excel Discussion (Misc queries) | |||
excel calendar - list of names displayed on calendar | Excel Worksheet Functions | |||
import calendar items from excel into outlook calendar | Excel Discussion (Misc queries) |