ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   in excel worksheet, add numbers in column k2&k3 (https://www.excelbanter.com/excel-worksheet-functions/74276-excel-worksheet-add-numbers-column-k2-k3.html)

monroe

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

Gary''s Student

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



All times are GMT +1. The time now is 03:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com