"daddylonglegs" wrote:


It depends what formula you have in G1.

Some functions, e.g. RIGHT, LEFT, MID always return a text result so if
you were using one of those the result might look like a number but it
would be text.

You can change the formula to co-erce the result to numeric, e.g.
instead of

=LEFT(A1,4)

use

=LEFT(A1,4)*+0*


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=567675

Thank you"daddylonglegs"
indeed I have been using one of the functions which you have mentioned and
thanks for the solution provided.
Steve