Only want to see half of my result

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Neall - 14 Sep 2007 17:12 GMT

I have a query and the result in each cell in the row is #####,###,###
however I only want to see ##### in each cell, I tired to custom format the
cells but it doesn’t work.

Any suggestions?

Thanks in advance

Signature

Neall

--
Neall

Reply to this Message

Mike H - 14 Sep 2007 17:28 GMT

In a helper row enter the formula

=left(a1,5) where 5 is them number of characters you want to see then hide
the row with all characters showing

Mike

> I have a query and the result in each cell in the row is #####,###,###
> however I only want to see ##### in each cell, I tired to custom format the
[quoted text clipped - 3 lines]
>
> Thanks in advance

Reply to this Message