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.