You can amend Gord's formula like so:

="(" & COLUMN()-1 & ", " & ROW()-1 & ")"

Enter this in cell A1 and copy it across. Then highlight row 1 and
copy it down - you will get the layout you want.

Hope this helps.

Pete

On Jul 24, 6:32 pm, kdogtrainer
wrote:
Your formula did the trick for putting the numbers across the way I needed
them but now when I try to add down it no longer works the way it did. This
is the result I am trying to get on the whole spreadsheet

(0, 0) (1, 0) (2, 0) (3, 0) (4, 0) (5, 0)
(0, 1) (1, 1) (2, 1) (3, 1) (4, 1) (5, 1)
(0, 2) (1, 2) (2, 2) (3, 2) (4, 2) (5, 2)

Thank you very much for your help



"Gord Dibben" wrote:
Enter in A1

="(" & COLUMN()-1 & ", 0)" returns (0, 0) (1, 0) (2, 0) (3, 0) (4, 0) (5, 0) as
it is copied across row 1

Gord Dibben MS Excel MVP

On Mon, 23 Jul 2007 15:36:02 -0700, kdogtrainer
wrote:

I want to be able number columns across the top of my excel sheet. EX.
(0, 0) (1, 0) (2, 0)
How do I get it to keep adding 1 number to the front # and keep the second #
as a zero?
When I do it down a column it works fine but when I try to do it across it
just keeps repeating itself so that I get:
(0, 0) (1, 0) (2, 0) (0, 0) (1, 0) (2, 0) instead of
(0, 0) (1, 0) (2, 0) (3, 0) (4, 0) (5, 0)
Any help would be greatly appreciated.- Hide quoted text -

- Show quoted text -