View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Roger Govier
 
Posts: n/a
Default doing my accpounts on excel

Hi Mike

Sounds like the column has been formatted as Date.
Select the ColumnFormatCellsNumberGeneral

If you would like the rows to be numbered automatically, if there is
something in column B of the row for example, then in A2 (assuming you
have headers in row 1, enter
=IF(B2="","",ROW())
and copy down

--
Regards

Roger Govier


"mike samuels" <mike wrote in message
...
when I try to enter a number in acolumn, the date comes up! how do I
just go
about numbering each row 1,2,3,4 etc. for future reference?