Only want to see half of my result
 

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 doesnt work.

Any suggestions?

Thanks in advance
--
Neall


--
Neall

Only want to see half of my result
 

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

"Neall" wrote:

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 doesnt work.

Any suggestions?

Thanks in advance
--
Neall


--
Neall