| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting formulas to values
I have this part # in a Word table:
-TK85-AX I try to copy it to an Excel file but I get a #NAME? error and on the fomula bar appears like =-TK85-AX What should I do? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Converting formulas to values
If it's just one cell, you can format the cell as text (in Excel) and paste into
the formula bar. If it's multiple cells, maybe you could format the cells as text and paste special|text. I didn't test this. Byron720 wrote: I have this part # in a Word table: -TK85-AX I try to copy it to an Excel file but I get a #NAME? error and on the fomula bar appears like =-TK85-AX What should I do? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Converting formulas to values
I would put it as ="-TK85-AX"
"Byron720" wrote: I have this part # in a Word table: -TK85-AX I try to copy it to an Excel file but I get a #NAME? error and on the fomula bar appears like =-TK85-AX What should I do? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Converting formulas to values
Usually helps if you pre-format the cells in Excel to Text format before the
paste. Gord Dibben MS Excel MVP On Thu, 10 Jul 2008 09:28:01 -0700, Byron720 wrote: I have this part # in a Word table: -TK85-AX I try to copy it to an Excel file but I get a #NAME? error and on the fomula bar appears like =-TK85-AX What should I do? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| converting hourly values into daily values | Excel Worksheet Functions | |||
| converting hour values to day mean values | Excel Worksheet Functions | |||
| Converting formulas to value | New Users to Excel | |||
| Cells converting ###s to formulas | Excel Discussion (Misc queries) | |||
| Short cuts for converting formulas to values | Excel Discussion (Misc queries) | |||
Hybrid Mode
