Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I add imported data with a - sign after it to make it add .
I import data from a program that has a negative sign after the numbers.
(example 100-) When I try to add the numbers, they will not add. I get zeros. I'm looking for a solution to get the fields to add. Thank you. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I add imported data with a - sign after it to make it add .
Here's a link to a Google site with a solution:
http://groups.google.com/group/micro...b2e7980d6db351 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I add imported data with a - sign after it to make it add .
Try this:
Select the range to be impacted <data<text-to-columns Click the [Next] button twice In Step_3: Set the column format to General Click the [Advanced] button Check: Trailing minus sign for negative numbers Clck [OK] Click [Finish] Does that help? *********** Regards, Ron XL2002, WinXP "Eileen White" wrote: I import data from a program that has a negative sign after the numbers. (example 100-) When I try to add the numbers, they will not add. I get zeros. I'm looking for a solution to get the fields to add. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
UPDATING IMPORTED DATA | Excel Worksheet Functions | |||
Importing Data | Excel Worksheet Functions | |||
imported text data converting to dates | Excel Discussion (Misc queries) | |||
Outside Data Imported to Excel | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions |