Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting numbers
I have a spreadheet full of dates (ex:1/4/2003). i want only the month
portion to show in a different cell. The trouble is that the month portion is to be shown as text (January - 1 is the month). I have managed to convert the 1 into January by using the Format-Cells command, but when I drag down to fill the other cells, they are all filled in as January, whereas the dates go through 12. How can I manage this? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting numbers | Excel Discussion (Misc queries) | |||
Converting positive numbers to negative numbers | Excel Worksheet Functions | |||
Converting numbers formatted as text to numbers | Excel Discussion (Misc queries) | |||
converting to numbers | Excel Worksheet Functions | |||
Converting numbers | Excel Worksheet Functions |