Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 29th 06, 03:39 PM posted to microsoft.public.excel.newusers
mike samuels
 
Posts: n/a
Default doing my accpounts on excel

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?

  #2   Report Post  
Old January 29th 06, 05:17 PM 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?



  #3   Report Post  
Old January 29th 06, 05:35 PM posted to microsoft.public.excel.newusers
Anne Troy
 
Posts: n/a
Default doing my accpounts on excel

Format the cell as a number. Format--Cells, choose Number and zero
decimals.
Excel doesn't have an "autonumber" feature. But you could do the following:
http://www.techonthenet.com/excel/fo...autonumber.php
Sorry about the popup.
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"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?



  #4   Report Post  
Old January 29th 06, 05:58 PM posted to microsoft.public.excel.newusers
Ron Coderre
 
Posts: n/a
Default doing my accpounts on excel

Try something like this:

Like Roger says, start by formatting your cells as numbers.

If your first auto-number cell is A1, enter a 1 in that cell.
Put this formula in the next cell down:
A2: =MAX($A$1:OFFSET(A2,-1,1))+1
(Even though it refers to itself, the OFFSET function will not trigger a
circular ref)
Copyt that formula down as far as you need.

Note: If you insert rows, the autonumbering will still work, but it will not
put a number in the blank cell that was added. If you need that cell to be
included in the series, just copy any of the formulas into the blank cell.
That cell and the ones below it will resequence.

If your first autonumber cell is not in row 1 then just put the formula in
the first autonumber cell.
Example:
A3: =MAX($A$1:OFFSET(A3,-1,1))+1
Since no numbers are above A3 the formula will return 1.

Adjust references to suit your situation.

Is that something you can work with?

***********
Regards,
Ron

XL2002, WinXP-Pro


"mike samuels" wrote:

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?

  #5   Report Post  
Old January 29th 06, 06:10 PM posted to microsoft.public.excel.newusers
Ron Coderre
 
Posts: n/a
Default doing my accpounts on excel

Drat! My fingers typed what I told them, instead of what I wanted!

Corrections:

A2: =MAX($A$1:OFFSET(A2,-1,1))+1
Should be
A2: =MAX($A$1:OFFSET(A2,-1,0))+1

and
A3: =MAX($A$1:OFFSET(A3,-1,1))+1
should be
A3: =MAX($A$1:OFFSET(A3,-1,0))+1

(Sorry about the typos)

***********
Regards,
Ron

XL2002, WinXP-Pro


"Ron Coderre" wrote:

Try something like this:

Like Roger says, start by formatting your cells as numbers.

If your first auto-number cell is A1, enter a 1 in that cell.
Put this formula in the next cell down:
A2: =MAX($A$1:OFFSET(A2,-1,1))+1
(Even though it refers to itself, the OFFSET function will not trigger a
circular ref)
Copyt that formula down as far as you need.

Note: If you insert rows, the autonumbering will still work, but it will not
put a number in the blank cell that was added. If you need that cell to be
included in the series, just copy any of the formulas into the blank cell.
That cell and the ones below it will resequence.

If your first autonumber cell is not in row 1 then just put the formula in
the first autonumber cell.
Example:
A3: =MAX($A$1:OFFSET(A3,-1,1))+1
Since no numbers are above A3 the formula will return 1.

Adjust references to suit your situation.

Is that something you can work with?

***********
Regards,
Ron

XL2002, WinXP-Pro


"mike samuels" wrote:

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?



  #6   Report Post  
Old January 31st 06, 05:19 AM posted to microsoft.public.excel.newusers
David McRitchie
 
Posts: n/a
Default doing my accpounts on excel

Hi Mike,
The solution you choose from those suppliedwould be dependent on if you want permanent
numbers that do not change if you insert delete rows, or if you want the
numbers to change if you insert/delete rows.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) Alain79 Excel Discussion (Misc queries) 4 June 14th 05 07:34 AM
Stop Excel Rounding Dates leinad512 Excel Discussion (Misc queries) 1 April 20th 05 04:19 PM
Hints And Tips For New Posters In The Excel Newsgroups Gary Brown Excel Worksheet Functions 0 April 15th 05 05:47 PM
Excel error - Startup (and Acrobat PDFMaker) gxdata Setting up and Configuration of Excel 0 February 4th 05 03:44 AM
Excel 2002 and 2000 co-install. Control Which Starts ? cnuk Excel Discussion (Misc queries) 2 January 17th 05 08:07 PM


All times are GMT +1. The time now is 12:53 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017