| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
My Numbers aren't numbers
You may have spaces included with the digits.
try doing a find replace and replace spaces with nothing. -- Hope this helps Martin Fishlock Please do not forget to rate this reply. "Cole" wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
My Numbers aren't numbers
Try clicking on a virgin cell, then click on the Paintbrush Icon in the upper
toolbar, then click on the problem cell...... hth Vaya con Dios, Chuck, CABGx3 "Cole" wrote: 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 |
| Reply |
| 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) | |||
Linear Mode
