Show Numeric Cell Value Instead of ####
 

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!

Show Numeric Cell Value Instead of ####
 

Maybe you can merge the two cells.

But be aware that merging cells can cause lots of trouble later on--sorting,
copy|pasting....

Rox123456 wrote:

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!

--

Dave Peterson

Show Numeric Cell Value Instead of ####
 

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.

"Dave Peterson" wrote:

Maybe you can merge the two cells.

But be aware that merging cells can cause lots of trouble later on--sorting,
copy|pasting....

Rox123456 wrote:

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!

--

Dave Peterson

Show Numeric Cell Value Instead of ####
 

You are correct in that assumption.


Gord Dibben MS Excel MVP

On Wed, 7 Feb 2007 11:23:00 -0800, Rox123456
wrote:

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