Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
summing a column gives me a date
I have a worksheet with each month listed on the columns. I have each row
totaled out, and wish to total expenditures for the month. But when I do, I get a date, and not a numerical value - which is what I want. What am I doing wrong. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
summing a column gives me a date
Without seeing the formula, it is impossible to give a meaningful
reply. Cordially, Chip Pearson Microsoft MVP 1998 - 2010 Pearson Software Consulting, LLC www.cpearson.com [email on web site] On Sun, 3 Jan 2010 15:13:01 -0800, jimfitegcs wrote: I have a worksheet with each month listed on the columns. I have each row totaled out, and wish to total expenditures for the month. But when I do, I get a date, and not a numerical value - which is what I want. What am I doing wrong. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
summing a column gives me a date
What are you doing wrong? Probably nothing. It's just Excel trying to be
helpful. Simply format the cell to a number with whatever precision you want. Regards, Fred "jimfitegcs" wrote in message ... I have a worksheet with each month listed on the columns. I have each row totaled out, and wish to total expenditures for the month. But when I do, I get a date, and not a numerical value - which is what I want. What am I doing wrong. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
summing a column gives me a date
"jimfitegcs" wrote:
I get a date, and not a numerical value - which is what I want. What am I doing wrong. Probably nothing. But it is impossible to say for sure without seeing the formulas and the types of data involved. (Klunk!) The date format is just that -- a format. Excel sometimes changes the format on us in an attempt to read our mind and give us what it thinks we want. It is frequently wrong. Sigh. And I don't think there is a way to turn off that feature. How annoying! Anyway, it's a "simple matter" to change the format to General or Number or whatever you want. After you do that, if the result is still not what you expect, post a reply with some details that will help us help you. ----- original message ----- "jimfitegcs" wrote: I have a worksheet with each month listed on the columns. I have each row totaled out, and wish to total expenditures for the month. But when I do, I get a date, and not a numerical value - which is what I want. What am I doing wrong. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
summing a column gives me a date
Probably the cell with the "totals" formula was preformatted as Date (unknown
to you). A simple remedy, just re-format that cell as number (via FormatCellsNumberOK). Success? hit the YES below -- Max Singapore --- "jimfitegcs" wrote: I have a worksheet with each month listed on the columns. I have each row totaled out, and wish to total expenditures for the month. But when I do, I get a date, and not a numerical value - which is what I want. What am I doing wrong. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summing values in a column if the date in another is of a certain month | Excel Discussion (Misc queries) | |||
Summing values in a column if the date in another is of a certain month | New Users to Excel | |||
Summing values in a column if the date in another is of a certain month | Excel Worksheet Functions | |||
summing column c based an column a criteria | Excel Worksheet Functions | |||
Summing one column based on date in another column | New Users to Excel |