Noob Excel 2003 help

C

chipslave

Should be an easy fix but I just can't seem to figure it out...

I want to have a column that goes something like this:

2182847100
2182847100
2182847101
2182847101
2182847102
2182847102

And so on...

Instead it is doing this:

2182847100
2182847100
2182847101
2182847101
2182847102
2182847102
2182847102.6 (but shows as 2182847103)
2182847103.05714 (but shows as 2182847103)
2182847103.51429 (but shows as 2182847104)

What am I doing wrong? I have had three people look into it and w
can't seem to fix it...

Thanks in advance...

Ja
 
E

ElsiePOA

I'm not sure what causes the problem, but there is a work around whic
can accomplish what you are trying to do.

Let's assume that 2182847102 is in cell A6. In cell A7 enter th
following formula:
=IF(A6=A5,A6+1,A6)

Copy that formula down as far as you need to, to complete you list.
Then - to convert the formula to actual numbers, select the entir
column and use copy - paste special, value
 
L

Lady Layla

Expand the width of your column



:
: Should be an easy fix but I just can't seem to figure it out...
:
: I want to have a column that goes something like this:
:
: 2182847100
: 2182847100
: 2182847101
: 2182847101
: 2182847102
: 2182847102
:
: And so on...
:
: Instead it is doing this:
:
: 2182847100
: 2182847100
: 2182847101
: 2182847101
: 2182847102
: 2182847102
: 2182847102.6 (but shows as 2182847103)
: 2182847103.05714 (but shows as 2182847103)
: 2182847103.51429 (but shows as 2182847104)
:
: What am I doing wrong? I have had three people look into it and we
: can't seem to fix it...
:
: Thanks in advance...
:
: Jay
:
:
: --
: chipslave
: ------------------------------------------------------------------------
: chipslave's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=14667
: View this thread: http://www.excelforum.com/showthread.php?threadid=262862
:
 
D

Dana DeLouis

Just one way. If the same two numbers are in A1:A2, then in A3 enter:
=A1+1.
Drag / Copy A3 down.

HTH
Dana DeLouis
 
Top