 Who's good with MS-Excel? |
|
|||||||||
 Oct 17 2004, 04:44 AM
Post
#1
|
|
|
Experienced Member  Group: Advanced Members Posts: 1,086 Joined: 16-January 04 From: Chandler AZ Member No.: 130  |
need a formula written, have been searching through the MS-help and can't seem to find a way to write the formula I want. I need a formula that shows the next number in column A when I enter data in column B.
For instance, if A2 says "1," then when I click on B3, I want A3 to show "2." I also need the number to show in five digits, e.g., 00001, 00002, etc. Where's the enguhneers out there??? (IMG:http://www.frrax.com/rrforum/style_emoticons/default/smile.gif) Rob |
 |
 
|
 |
Replies
|
Oct 17 2004, 09:39 AM
Post
#2
|
|
|
Nothing says 'I love you.' like a box of Hydroshoks Group: Moderators Posts: 5,284 Joined: 23-December 03 From: Granbury, TX Member No.: 4 |
=(cell number)+1
in the target cell should get it done. However, this kind of throws me off ... QUOTE then when I click on B3, I want A3 to show "2." You want to just click in the cell and the next cell over to ratchet up one number? Like a counter? No data entered? hmmmm ... For the number formatting Format>Cell>Number>Custom Click on the single digit "0" and add the number of digits you want shown. |
|
|
|
Posts in this topic
Rob Hood Who's good with MS-Excel? Oct 17 2004, 04:44 AM
RedHardSupra First part is either trivial or I'm not gettin... Oct 17 2004, 07:55 AM Jeff94TA QUOTE (mitchntx @ Oct 17 2004, 04:39 AM)For t... Oct 17 2004, 05:36 PM Rob Hood ok, I'm getting there - thanks for all the inp... Oct 17 2004, 09:27 PM y5e06 edited to add if statement (always check your work... Oct 18 2004, 12:40 AM Rob Hood Morgan, thanks for the input. I did try your sugg... Oct 18 2004, 01:20 AM mitchntx OK ... now I'm curious ...
What the hell are ... Oct 18 2004, 01:24 AM Rob Hood pretty much banging my head like that emoticon...
... Oct 18 2004, 01:43 AM felton316 If you are just generating a auto numbering sequen... Oct 18 2004, 01:49 AM mitchntx I am convinced that is I wanted to know how a blac... Oct 18 2004, 03:29 AM trackbird QUOTE (mitchntx @ Oct 17 2004, 10:29 PM)I am ... Oct 18 2004, 03:51 AM
rmackintosh QUOTE (mitchntx @ Oct 17 2004, 09:29 PM)I am ... Oct 18 2004, 03:44 PM |
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:
| Lo-Fi Version | Time is now: 5th May 2025 - 12:07 AM |