Format Cells?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

@Homeonthecouch - 23 Mar 2008 02:36 GMT

Hello,
Not sure if this is the easiest way to do this but I am wanting to create a series of cells
A1 10.0.0
A2 10.0.1
A3 10.0.2
Etc.
A14 10.0.15
A15 10.1.0
A16 10.1.1
A17 10.1.2
Etc.

Is there an easy method of doing this perhaps with a Format function or will I have to create a sum to work out the
last cell plus .0.1?

Any help is appreciated.

Andrew.

Reply to this Message

Max - 23 Mar 2008 09:06 GMT

Give this a try in any starting cell, eg in A1:
=10&"."&INT((ROWS($1:1)-1)/16)&"."&MOD(ROWS($1:1)-1,16)
Copy down

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> Hello,
> Not sure if this is the easiest way to do this but I am wanting to create
[quoted text clipped - 16 lines]
>
> Andrew.

Reply to this Message

Dave Peterson - 23 Mar 2008 13:55 GMT

Just to piggy back on Max's response.

You may want to end up with values that look like:

10.00.00
10.00.01
10.00.02
10.00.03
10.00.04
10.00.05
10.00.06

(You may find sorting your data much easier with this format.)

You could a minor modification to Max's formula to get it:
=10&"."&TEXT(INT((ROWS($1:1)-1)/16),"00")&"."&TEXT(MOD(ROWS($1:1)-1,16),"00")

> Give this a try in any starting cell, eg in A1:
> =10&"."&INT((ROWS($1:1)-1)/16)&"."&MOD(ROWS($1:1)-1,16)
[quoted text clipped - 25 lines]
> >
> > Andrew.

Signature

Dave Peterson

Reply to this Message

Rate this thread: