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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLOOK with Index - How to get results across instead of down? 3
Adding a column of numbers, with a condition 3
Count Numeric Value with condition 5
Cell format - put hyphen where zero value would be. 2
conditional format of adjacent cell with different range and crite 1
Windows XP Listbox with 3 columns, cutting formatted value 0
condionally formatting based on another cells formatting? 2
converting text cell to numeric cell 5

Back
Top