| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel addition of column
Please help, I have a very long list of figures for which I need a total.
They have been listed without 'thousand separator'. Now I cannot format the cells to have the 'thousand separator' and neither Autosum or Formula for addition will not work. -- Cheers |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Excel addition of column
It sounds like probably your "numbers" are actually TEXT formatted. There
are several methods to make the conversion back to numbers, sometimes one works where the others won't.....dunno why. Try typing a 1 in an unused cell, then clicking on it and oing COPY, then clicking on your column of data and doing PasteSpecial Multiply.......... There are other ways if that one don't work. Vaya con Dios, Chuck, CABGx3 "LSP Marg" wrote: Please help, I have a very long list of figures for which I need a total. They have been listed without 'thousand separator'. Now I cannot format the cells to have the 'thousand separator' and neither Autosum or Formula for addition will not work. -- Cheers |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Check COlumn - Excel VBA | Excel Discussion (Misc queries) | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| How do I reference every "n" cell in a column in Excel? | Excel Worksheet Functions | |||
| Excel should provide an easy way to switch a column into a row, n. | Excel Discussion (Misc queries) | |||
| getting data from 2 excel sheets automatically | Excel Worksheet Functions | |||
Linear Mode
