Click to See Complete Forum and Search --> : Excel Question! Pls Help!


handan2002
September 30th, 2003, 07:46 AM
Example:

In Cell A1, I have the value: 378456

For Cell A2, I want the same value as A1, with an extra "<" symbol in front of it.

How do I do it?

Pls Reply!

Thx

P.S. These cells are used as a criteria in a DMIN function

Tom Frohman
September 30th, 2003, 08:31 AM
in a2 put
=concatenate("<",text(a1,"0"))