Prev: Rename Worksheet Tab as File Name Using a Macro
Next: 2007 version of Excel
From: CHAD on 24 Dec 2009 12:14
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
From: CLR on 24 Dec 2009 12:23
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
 | 
Pages: 1
Prev: Rename Worksheet Tab as File Name Using a Macro
Next: 2007 version of Excel