can i add a word before a sum from a different sheet.

ie: i have a total on sheet 1, and on sheet 2 in a cell i place =then i
click on the cell that i want from shhet 1. but what i want to see on sheet 2
is the word TOTAL in front of the number that comes from the sheet 1 cell.

if anyone could help that would be great.

thank you

Format the cell on sheet2 as CUSTOM Total 0

or

use this formula on sheet2 instead,

="Total " & Sheet1!A1

Vaya con Dios,
Chuck, CABGx3

"CHAD" wrote:

can i add a word before a sum from a different sheet.

ie: i have a total on sheet 1, and on sheet 2 in a cell i place =then i
click on the cell that i want from shhet 1. but what i want to see on sheet 2
is the word TOTAL in front of the number that comes from the sheet 1 cell.

if anyone could help that would be great.

thank you