| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cannot autosum after import
Hi guys
I'm importing numbers from a custom application into excel, after the import I cannot autosum, but if i manually remove the number and re-type it works fine. Any ideas? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cannot autosum after import
Is the data text being imported as text?
"DavidB" wrote: Hi guys I'm importing numbers from a custom application into excel, after the import I cannot autosum, but if i manually remove the number and re-type it works fine. Any ideas? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cannot autosum after import
The cells seem to be formatted as text after the import
Is the data text being imported as text? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cannot autosum after import
Numbers came in as text.
Format all cells as General. Copy an empty cell. Select the data range and Paste SpecialAddOKEsc Now try the autosum. Gord Dibben MS Excel MVP On Wed, 19 Jul 2006 15:38:21 +0100, "DavidB" wrote: Hi guys I'm importing numbers from a custom application into excel, after the import I cannot autosum, but if i manually remove the number and re-type it works fine. Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| import filtered data | Excel Discussion (Misc queries) | |||
| I NEED TO IMPORT MORE THAN THE 65,536 LINES EXCEL ALLOWS | Excel Worksheet Functions | |||
| import data with macro | Excel Discussion (Misc queries) | |||
| import data using macro | Excel Discussion (Misc queries) | |||
| autosum problems | Excel Worksheet Functions | |||
Linear Mode
