Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Hi. I'm using Excel 2007. I have a row with a cell that contains a number,
say 4444. I want to select this number and drag down so the following cells below this row and cell with a number with appear as 4444.1, the next row and cell below this as 4444.2, ... 4444.10, 4444.11, and so on, by dragging down the mouse. Can this be done? And how should I format the column? As a number, as general, as ...? I tried holding down the Ctrl key, or the Alt key, but the result was: 4444.1, 4445.1, etc. If I format the column as a number, when I resort, the problem appears after 4444.10, because the resulting sort will be 4444.1, 4444.10, 4444.11, etc. In other words, I have to have the decimal point after the number, and I have to sort in the proper order, that is, 1 to 10 or 1 to 20, etc. If this can be done, and if you understood my fuzzy description, please explain in simple English and step by step. Thank you very much. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
MS Excel number question | Excel Discussion (Misc queries) | |||
Number Formatting Question | Excel Worksheet Functions | |||
Number formatting question | Excel Discussion (Misc queries) | |||
number formatting question | Excel Worksheet Functions | |||
Number formatting question | Excel Worksheet Functions |