| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
in excel worksheet, add numbers in column k2&k3
I can sum columns A thru j But the same functions will not work in column K.
I get numbers that look like a date from long ago such as 10/26/1900, 3:10. Strange. Please help. Thank you |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
in excel worksheet, add numbers in column k2&k3
Select these strange-looking cells and pull-down:
Format Cells... Number General -- Gary's Student "monroe" wrote: I can sum columns A thru j But the same functions will not work in column K. I get numbers that look like a date from long ago such as 10/26/1900, 3:10. Strange. Please help. Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet | Excel Worksheet Functions | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| Excel link to data in other worksheet only refreshes one column | Excel Discussion (Misc queries) | |||
| how write excel formula numbers in column => &=< between 20-40 | New Users to Excel | |||
Linear Mode
