Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why can't I use SUM when pasting HTML code into new sheet.
I have tried using the SUM function from different cells to no avail.
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why can't I use SUM when pasting HTML code into new sheet.
Hi
It sounds as though the values may have come across as Text. In a spare cell on your sheet, enter the number 1. Copy the cell, mark the range of Data you have copied and Paste SpecialMultiply. That may well coerce the values to numeric. Alternatively there may be extraneous spaces, or the non-breaking space character Char(160) embedded within the data. Use David McRitchie's TRIMALL() function to clean up the data. http://www.mvps.org/dmcritchie/excel/join.htm#trimall -- Regards Roger Govier "Crosscatch" wrote in message ... I have tried using the SUM function from different cells to no avail. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I Save an Excel spread sheet as html text? | Excel Discussion (Misc queries) | |||
Code to protect sheet | Excel Worksheet Functions | |||
Change case...help please | Excel Worksheet Functions | |||
Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
how can i select all the cells with same color on a sheet if there are multipale colors by vba code | Charts and Charting in Excel |