 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, 05:36 PM
Post
#2
|
|
|
Advanced Member Group: Advanced Members Posts: 461 Joined: 24-December 03 From: Orlando, FL Member No.: 34 |
QUOTE (mitchntx @ Oct 17 2004, 04:39 AM) For the number formatting Format>Cell>Number>Custom Click on the single digit "0" and add the number of digits you want shown. It doesn't look like he's talking about decimal places but placing zeros in front of the number. Format>Cell>Custom In the box next to "Type:" just erase what's there and type in 00000 to show four zeros. This will show three zeros when you get into double digits and so on. On Edit: After reading yours again Mitch I believe we are saying the same thing. Sorry about that. |
|
|
|
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 mitchntx =(cell number)+1
in the target cell should get it... Oct 17 2004, 09:39 AM 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:02 AM |