formating incrementing numbers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bert - 04 Oct 2006 22:21 GMT

It almost seems silly asking this question, but I can't figure out how to do
this.
I need to come up with a grid 4 cells X 100 cells each cell containing
numbers in the following format.
A B C D
1 06-001 06-002 06-003 06-004
2 06-005 06-006 06-007 06-008
all the way up to ...
100 06-397 06-398 06-399 06-400
(Or however the lost rows work out)

I'm trying formulas, but no either I loose the two leading zeros in the
second part of the number, or get some kind of error message.

Thanks.
Bert.

Reply to this Message

Pete_UK - 04 Oct 2006 22:30 GMT

Enter the number 6001 in A1, then use Format | Cells on this cell,
giving it a Custom format of 00-000. Then in B1 enter the formula:

=A1+1

and the format should be the same. Copy B1 to C1:D1. Enter this formula
in A2:

=A1+4

and again the format should follow it. Copy B1:D1 into B2:D2. Then
highlight A2:D2 and copy these cells down into A3:A100, and you should
have what you want.

Hope this helps.

Pete

> It almost seems silly asking this question, but I can't figure out how to do
> this.
[quoted text clipped - 12 lines]
> Thanks.
> Bert.

Reply to this Message

Pete_UK - 05 Oct 2006 09:59 GMT

You're welcome, Bert - thanks for the feedback.

Pete

Bert wrote:

> Pete:
> Thanks for your speedy help with this. Your suggestion worked great!
[quoted text clipped - 35 lines]
> > Thanks.
> > Bert.

Reply to this Message

Dave Peterson - 04 Oct 2006 22:42 GMT

Put this in A1:
="06-"&TEXT((4*(ROW()-1))+COLUMN(),"000")
Drag to the right (to D1)
and select those four cells (a1:d1) and drag down to row 100.

> It almost seems silly asking this question, but I can't figure out how to do
> this.
[quoted text clipped - 12 lines]
> Thanks.
> Bert.

Signature

Dave Peterson

Reply to this Message