| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if i cut and paste from html into excel, i cannot create formulas
I am cutting from Trade station using HTML, and pasting into excel. When I
try to create a formula, I get error #value. Thanks John |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if i cut and paste from html into excel, i cannot create formulas
That's because the format of the cell isn't correct.
Typically, if you copy a blank column right-click on the data column paste special/formats it will be corrected. "John Spann" wrote: I am cutting from Trade station using HTML, and pasting into excel. When I try to create a formula, I get error #value. Thanks John |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if i cut and paste from html into excel, i cannot create formu
Thank you for your response. This is not the problem. The numbers from html
are not recognized as numbers in excel, even though they look like numbers. I even formatted them as numbers. But when I try to create a formula, I get #value! I did paste special. Thanks again. John "Sean Timmons" wrote: That's because the format of the cell isn't correct. Typically, if you copy a blank column right-click on the data column paste special/formats it will be corrected. "John Spann" wrote: I am cutting from Trade station using HTML, and pasting into excel. When I try to create a formula, I get error #value. Thanks John |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if i cut and paste from html into excel, i cannot create formu
You have to edit them as well as re-format them.
What is the formula? -- --- HTH Bob (change the xxxx to gmail if mailing direct) "John Spann" wrote in message ... Thank you for your response. This is not the problem. The numbers from html are not recognized as numbers in excel, even though they look like numbers. I even formatted them as numbers. But when I try to create a formula, I get #value! I did paste special. Thanks again. John "Sean Timmons" wrote: That's because the format of the cell isn't correct. Typically, if you copy a blank column right-click on the data column paste special/formats it will be corrected. "John Spann" wrote: I am cutting from Trade station using HTML, and pasting into excel. When I try to create a formula, I get error #value. Thanks John |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if i cut and paste from html into excel, i cannot create formu
After formatting, have you tried, from the 'Data' menu, the 'Text to Columns'
option? I've found that formatting number data as 'General' in cases like this helps. -- T Tipsy "John Spann" wrote: Thank you for your response. This is not the problem. The numbers from html are not recognized as numbers in excel, even though they look like numbers. I even formatted them as numbers. But when I try to create a formula, I get #value! I did paste special. Thanks again. John "Sean Timmons" wrote: That's because the format of the cell isn't correct. Typically, if you copy a blank column right-click on the data column paste special/formats it will be corrected. "John Spann" wrote: I am cutting from Trade station using HTML, and pasting into excel. When I try to create a formula, I get error #value. Thanks John |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if i cut and paste from html into excel, i cannot create formu
An example would be:
cell f3 is 81.61 cell f4 is 81.30 Formula in cell g4 is: =f4-f3 The result is #value! John "Bob Phillips" wrote: You have to edit them as well as re-format them. What is the formula? -- --- HTH Bob (change the xxxx to gmail if mailing direct) "John Spann" wrote in message ... Thank you for your response. This is not the problem. The numbers from html are not recognized as numbers in excel, even though they look like numbers. I even formatted them as numbers. But when I try to create a formula, I get #value! I did paste special. Thanks again. John "Sean Timmons" wrote: That's because the format of the cell isn't correct. Typically, if you copy a blank column right-click on the data column paste special/formats it will be corrected. "John Spann" wrote: I am cutting from Trade station using HTML, and pasting into excel. When I try to create a formula, I get error #value. Thanks John |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if i cut and paste from html into excel, i cannot create formu
John, after you import your data, put 1 in a separate cell, and copy it.
Then select your data cells and paste special - multiply. This should turn them into numbers. -- Sincerely, Michael Colvin "John Spann" wrote: An example would be: cell f3 is 81.61 cell f4 is 81.30 Formula in cell g4 is: =f4-f3 The result is #value! John "Bob Phillips" wrote: You have to edit them as well as re-format them. What is the formula? -- --- HTH Bob (change the xxxx to gmail if mailing direct) "John Spann" wrote in message ... Thank you for your response. This is not the problem. The numbers from html are not recognized as numbers in excel, even though they look like numbers. I even formatted them as numbers. But when I try to create a formula, I get #value! I did paste special. Thanks again. John "Sean Timmons" wrote: That's because the format of the cell isn't correct. Typically, if you copy a blank column right-click on the data column paste special/formats it will be corrected. "John Spann" wrote: I am cutting from Trade station using HTML, and pasting into excel. When I try to create a formula, I get error #value. Thanks John |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if i cut and paste from html into excel, i cannot create formu
I can't replicate the problem, but try this
=--F4-F3 -- --- HTH Bob (change the xxxx to gmail if mailing direct) "John Spann" wrote in message ... An example would be: cell f3 is 81.61 cell f4 is 81.30 Formula in cell g4 is: =f4-f3 The result is #value! John "Bob Phillips" wrote: You have to edit them as well as re-format them. What is the formula? -- --- HTH Bob (change the xxxx to gmail if mailing direct) "John Spann" wrote in message ... Thank you for your response. This is not the problem. The numbers from html are not recognized as numbers in excel, even though they look like numbers. I even formatted them as numbers. But when I try to create a formula, I get #value! I did paste special. Thanks again. John "Sean Timmons" wrote: That's because the format of the cell isn't correct. Typically, if you copy a blank column right-click on the data column paste special/formats it will be corrected. "John Spann" wrote: I am cutting from Trade station using HTML, and pasting into excel. When I try to create a formula, I get error #value. Thanks John |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if i cut and paste from html into excel, i cannot create formu
Michael's post worked for me. I was able to replicate the issue, and this
resolved it. "Michael" wrote: John, after you import your data, put 1 in a separate cell, and copy it. Then select your data cells and paste special - multiply. This should turn them into numbers. -- Sincerely, Michael Colvin "John Spann" wrote: An example would be: cell f3 is 81.61 cell f4 is 81.30 Formula in cell g4 is: =f4-f3 The result is #value! John "Bob Phillips" wrote: You have to edit them as well as re-format them. What is the formula? -- --- HTH Bob (change the xxxx to gmail if mailing direct) "John Spann" wrote in message ... Thank you for your response. This is not the problem. The numbers from html are not recognized as numbers in excel, even though they look like numbers. I even formatted them as numbers. But when I try to create a formula, I get #value! I did paste special. Thanks again. John "Sean Timmons" wrote: That's because the format of the cell isn't correct. Typically, if you copy a blank column right-click on the data column paste special/formats it will be corrected. "John Spann" wrote: I am cutting from Trade station using HTML, and pasting into excel. When I try to create a formula, I get error #value. Thanks John |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
