Imported negative values

[glen.e.mettler]

Using 2003
I have imported data with numeric negative values. I have formated the
column to numeric data. However, the value does not evaluate to
negative - ie - A5 = -10. When I select another cell and enter = A5<0
It should evaluate to TRUE however it evaluates to FALSE. If I
manually reenter the data as -10, it evaluates to TRUE.

I don't want to manually reenter all the data. How can I get Excel to
"see" this as a proper negative number?

Glen

 

[Jan De Messemaeker]

Hi glen,

This newsgroup is devoted to VBA for Microsoft Project.
Ther must be Excel newsgroups where you will probably get better help!

 

[John]

Using 2003
I have imported data with numeric negative values. I have formated the
column to numeric data. However, the value does not evaluate to
negative - ie - A5 = -10. When I select another cell and enter = A5<0
It should evaluate to TRUE however it evaluates to FALSE. If I
manually reenter the data as -10, it evaluates to TRUE.

I don't want to manually reenter all the data. How can I get Excel to
"see" this as a proper negative number?

Glen

Glen,
First of all you have posted to a newsgroup that is destined to be
deleted. Second of all, questions in this newsgroup are for Microsoft
Project, a planning and scheduling application. You will have better
luck posting to an appropriate Excel newsgroup.

John
Project MVP