Excel: need wide value to overflow into next cell

[adumitrescu]

I have a worksheet formatted like a report, with many levels of indenting. I need the numerical values to overflow into the next cell, instead of displaying "#####" for columns too narrow. Below is a simplified version, to display the desired output.
[tt]
data 9999
data 9999
data 9999
data 9999
data 9999
data 9999
data 9999
[/tt]
This is a *working* file, so I can't just cook it up in the report format I need. I wish to keep these cells 'values', and not convert them to text. I already tried a bunch of redirection using =text() then hiding the real numbers, but this just got too difficult to work with.

Thanks for any suggestions.

 

[SkipVought]

If it's ONLY a report, convert all values to TEXT
[tt]
=TEXT(MyValRef, "00000")
[/tt]
or how many leading zeros you want

or "#" without regard to leading zeros (right justify)

Skip,
[sub]
[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount! [/sub]

 

[xlbo]

how about just making the column wider ?? or merging several columns for this particular set of data...

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[KenWright]

Just have a button on your sheet that runs a piece of code to autosize all the affected columns (Or just double click the right of the header to do a single column). Values cannot flow across the same way text will, so you either merge cells (Yuk), centre across selection individually, or increase the column width that contains all the values. Given that what you have looks like a form of indenture you would see within Project, then I'm guessing you would want to resize the entire column anyway.

Regards
Ken................

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------