Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
i am trying to type 2-1-1 in a cell and want the next cell to be 2-1-2 and so
on. But my cell keeps coming up a 36893. i have tried formating cell to general and custom. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
'2-1-1
and copy down |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
sorry
drag down instead of copying |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Pre-format cells as Text
Enter 2-1-1 Drag/copy down Gord Dibben MS Excel MVP On Sun, 20 Jul 2008 23:01:00 -0700, Rama wrote: i am trying to type 2-1-1 in a cell and want the next cell to be 2-1-2 and so on. But my cell keeps coming up a 36893. i have tried formating cell to general and custom. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
formating a cell | Excel Discussion (Misc queries) | |||
FORMATING WITHIN CELL | Excel Worksheet Functions | |||
Formating cell | Excel Worksheet Functions | |||
Cell to follow content AND/OR formating of another cell | Excel Discussion (Misc queries) | |||
cell formating | Excel Worksheet Functions |