WHEN I TOTAL A COLUMN I GET A RESULT IN WRONG FORMAT

C

cannotgeitright

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!
 
M

Ms-Exl-Learner

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Column total is wrong 5
Sports summary sheet - think I put this in wrong place originally 1
Peculiar default cell format 1
Running total in blank cells 3
How to ignore a column of numbers in Grand Total for rows 1
Running Total Column 1
Adding up total hours worked on employee schedule using various criteria 0
find common text in cell in column in sheet then return total amou 1

Top