the line is extending to the next cell

[HuaMin]

Hi,
Could anyone pls help on this?

http://cid-17ec75244bac022f.skydrive.live.com/self.aspx/.Public/t11.doc

Bst Rgds,
HuaMin

 

[Simon Lloyd]

What is it you are asking?, as far as i can tell if the text did exten
out of cell C7 it would destroy the look of your sheet, that said
believe you have the cell formatted as a number, format it as TEXT i
should help


Hi
Could anyone pls help on this

't11.doc - Windows Live' (http://tinyurl.com/23hyzz5

Bst Rgds
HuaMin


--
Simon Lloyd

Regards
Simon Lloyd
'Excel Chat' (http://www.thecodecage.com/forumz/chat.php)

 

[HuaMin]

Thanks. Is there any way to avoid that the contents of the cell will extend
to the one beside it, even if the 'beside' cell is empty?

 

[HuaMin]

Simon,
can you pls see this?
http://cid-17ec75244bac022f.skydrive.live.com/self.aspx/.Public/t12.doc

Thanks

 

[Gord Dibben]

Format the cell to "wrap text"


Gord Dibben MS Excel MVP

 

[HuaMin]

Many thanks to all. Mickey, your 1st way is enough!

 

[Gord Dibben]

And that space will probably give you grief at some point.


Gord Dibben MS Excel MVP