| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I cannot paste values as numbers
I copied a column of data off the internet, tried pasting both as Special
(Values) and normal. In both cases the column with #s does not 'take'. Even though I set the formatting as Number/2 Decimal Places it will not add the decimal places nor will it sort. I copied and tried to repaste as Special/Values an no matter what I do it won't recognize as #s. Any thoughts appreciated. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I cannot paste values as numbers
create a new column. Multiply the value in your existing column by 1, thus
forcing the numeric format. "msnyc07" wrote: I copied a column of data off the internet, tried pasting both as Special (Values) and normal. In both cases the column with #s does not 'take'. Even though I set the formatting as Number/2 Decimal Places it will not add the decimal places nor will it sort. I copied and tried to repaste as Special/Values an no matter what I do it won't recognize as #s. Any thoughts appreciated. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I cannot paste values as numbers
If you mean as in =C1*1 I did that and get #Value!
"TC" wrote: create a new column. Multiply the value in your existing column by 1, thus forcing the numeric format. "msnyc07" wrote: I copied a column of data off the internet, tried pasting both as Special (Values) and normal. In both cases the column with #s does not 'take'. Even though I set the formatting as Number/2 Decimal Places it will not add the decimal places nor will it sort. I copied and tried to repaste as Special/Values an no matter what I do it won't recognize as #s. Any thoughts appreciated. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I cannot paste values as numbers
I found the problem. The entries all had a trailing space so were being
treated as text regardless. So I did =(LEFT(F26058,9))*1 and it worked out. Thanks "msnyc07" wrote: If you mean as in =C1*1 I did that and get #Value! "TC" wrote: create a new column. Multiply the value in your existing column by 1, thus forcing the numeric format. "msnyc07" wrote: I copied a column of data off the internet, tried pasting both as Special (Values) and normal. In both cases the column with #s does not 'take'. Even though I set the formatting as Number/2 Decimal Places it will not add the decimal places nor will it sort. I copied and tried to repaste as Special/Values an no matter what I do it won't recognize as #s. Any thoughts appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find values in multiple cells and paste row values | Excel Discussion (Misc queries) | |||
| can you change the default paste method? (paste values) | Excel Discussion (Misc queries) | |||
| Paste Values not pasting numbers | Excel Discussion (Misc queries) | |||
| can numbers be assigned to values, replacing values for numbers | Excel Discussion (Misc queries) | |||
Hybrid Mode
