| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| First Half / Second Half Month Budget | Excel Worksheet Functions | |||
| Compare 1st Half & 2nd Half of 2008. | Excel Worksheet Functions | |||
| print half of rows on left and other half on right | Excel Discussion (Misc queries) | |||
| Advanced formula - Return result & Show Cell Reference of result | Excel Worksheet Functions | |||
| vlookup based on random result returns incorrect result | Excel Worksheet Functions | |||
Linear Mode
