Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
My Numbers aren't numbers
Hi
I have downloaded data from the web and put it into excel. When I use cell contents that appear to be numbers in my formula i get #value. The cell is formatted as number. I have tried entering a 1 in a blank cell and copypastespecialmultipy, but this does not work. If I edit the cell and over type one of the digits (8 digit number) the formula works. How can I fix this without having to edit each cell? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Completely baffled on what should be simple | Excel Discussion (Misc queries) | |||
conditional formatting | Excel Worksheet Functions | |||
How to generate sets of random numbers without having duplicates | Excel Worksheet Functions | |||
Why are 1/2 my numbers imported as text and the rest as numbers? | Excel Discussion (Misc queries) | |||
Count comma separated numbers, numbers in a range with dash, not t | Excel Discussion (Misc queries) |