Show Numeric Cell Value Instead of ####

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'd like to have a narrow column of numeric data extend/flow into the
adjacent right hand column, instead of showing ###.

ie

|12|455|
|11|3
|76|888|

Instead of

|##| |
|##| |
|##| |

Can't find anything in Cell or Column formating to accomplish this. Help
please!
 
Maybe you can merge the two cells.

But be aware that merging cells can cause lots of trouble later on--sorting,
copy|pasting....
 
Merging is not a good option, as I will be using the second column to sum the
previous numbers.

I'm trying to create a staggered column effect, as is common in financial
statements.

I'm beginning to think Excel does not allow numbers to flow across columns,
unless they are formatted as text.
 
Back
Top