Only want to see half of my result

[Guest]

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

 

[Guest]

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