Copying down..

Hello all,

is there a way or formula that I can copy down the following up to 500

Figure 1:
Figure 2:
Figure 3:

...

Figure 500:

Thank you

Thanks Glenn,

It works.

thong

Another solution would be to use a custom number format.

Choose the column you wish to use.
Format cells - Number - Custom
Choose the single 0
In the top box with the 0, type "Figure "0":"
Click OK

Now whatever number you put in that column it will display as Figure XX: The advantage of this method is that these are numbers, not text. You can sort, filter, work with these as you do with any other numbers. If you sorted by a different column and wanted to go back to Figure order you can sort by this column.

If you need a formula for arbitrary ranges/tables, use:

="Figure" & ROW() - 1
where 1 is the row number of your table header (above formula will put value Figure1 into 2nd row).

If you already have numbers as the value of some other formula and you want to change the display of the numbers to include "Figure":

right click your selection > Format Cells...
on Number tab, choose Custom
type "Figure"General as your custom number format
(Use "Figure"0 if you need to convert possibly floating point numbers to nearest lower integer value)