Perfect Ron, thank you so much.

And thank you Biff.

Felix


--
nyrfan
------------------------------------------------------------------------
nyrfan's Profile: http://www.excelforum.com/member.php...o&userid=31192
View this thread: http://www.excelforum.com/showthread...hreadid=508606

Ron,

I still have a bit of a problem.

When entering a # over 1001 everthing is aok, when a number of less
then or = to 1000 there is still a problem.


Hope I explain this in a way that makes sence. Both cells, the one
with 1000 and over 1000 thousand are tied in to formulas. When a #
less then 1000 is entered the cell (b2) has nothing in it and the all
the cells tied to that with a formula gets a "value" statement. How do
I correct that?

For instance:

888 entered
888 in B1
B2 s blank

c5 tied to b2 with a formula has a "value" statement. The formula in
c5 similar to: is b2*a2 (which is 4.5)


Thanks,
Felix


--
nyrfan
------------------------------------------------------------------------
nyrfan's Profile: http://www.excelforum.com/member.php...o&userid=31192
View this thread: http://www.excelforum.com/showthread...hreadid=508606

Hi!

Which formulas did you use?

If any of the formulas you used have "" in them, just replace that with 0.

For example:

=IF(A11000,A1-B1,"")

Change that to:

=IF(A11000,A1-B1,0)

Biff

"nyrfan" wrote in
message ...

Ron,

I still have a bit of a problem.

When entering a # over 1001 everthing is aok, when a number of less
then or = to 1000 there is still a problem.


Hope I explain this in a way that makes sence. Both cells, the one
with 1000 and over 1000 thousand are tied in to formulas. When a #
less then 1000 is entered the cell (b2) has nothing in it and the all
the cells tied to that with a formula gets a "value" statement. How do
I correct that?

For instance:

888 entered
888 in B1
B2 s blank

c5 tied to b2 with a formula has a "value" statement. The formula in
c5 similar to: is b2*a2 (which is 4.5)


Thanks,
Felix


--
nyrfan
------------------------------------------------------------------------
nyrfan's Profile:
http://www.excelforum.com/member.php...o&userid=31192
View this thread: http://www.excelforum.com/showthread...hreadid=508606

That did it Biff, thanks a LOT.

Felix


--
nyrfan
------------------------------------------------------------------------
nyrfan's Profile: http://www.excelforum.com/member.php...o&userid=31192
View this thread: http://www.excelforum.com/showthread...hreadid=508606