|Subject:||RE: How do I add imported data with a - sign after it to make it add .|
|Posted by:||Ron Coderre|
|Date:||Thu, 18 May 2006|
Select the range to be impacted
Click the [Next] button twice
Set the column format to General
Click the [Advanced] button
Check: Trailing minus sign for negative numbers
Does that help?
"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.
How do I add imported data with a - sign after it to make it add . posted by Eileen White on Thu, 18 May 2006