Prev: Combine various cells in to one array
Next: condditional farmulation
From: cannotgeitright on 21 May 2010 05:12
I am working on sheet 2 and when i try to get the total i get what looks like
a date instead of total. I have tried copying the group to another sheet and
it works fine but i don't want to copy the whole sheet. Help!

From: Ms-Exl-Learner on 21 May 2010 05:40
Select your formula cell and Do Right Click>>Format
Cells>>Number>>Category>>Select General and give Ok.

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"cannotgeitright" wrote:

> I am working on sheet 2 and when i try to get the total i get what looks like
> a date instead of total. I have tried copying the group to another sheet and
> it works fine but i don't want to copy the whole sheet. Help!
>
From: Jacob Skaria on 21 May 2010 05:41
Did you try formatting the cell to General.

--
Jacob (MVP - Excel)


"cannotgeitright" wrote:

> I am working on sheet 2 and when i try to get the total i get what looks like
> a date instead of total. I have tried copying the group to another sheet and
> it works fine but i don't want to copy the whole sheet. Help!
>
 | 
Pages: 1
Prev: Combine various cells in to one array
Next: condditional farmulation