Is this possible at all?
To left align a cell with a number. and have it overflow to the next cell/s.
I know that numbers can be formatted to Text but there are issues if you have a formula in the cell, and so on.
Reason is that I'm trying to avoid merging cells.
Snapshot.png
Home/Alignment and click the left alignment icon.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Thanks for responding.
This doesn't make the number overflow to the adjacent cell though.
It does if it's Text though.
I need it as a number.
Why can't you simply change the column width?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
I need the column width to remain fixed as it is used like a grid pad for calculations.
Puzzled. The column width will autoadjust. You can fix the column width and if it's set too narrow, it'll show as ###. I don't see why you would even dream of merging cells.
It's because there is working all over the place.
Once I widen the column width, parts overflow past the page.
I'm puzzled, too. Seems that aesthetics (form) is coming before function, which is like putting the cart before the horse.
Then adjust the print page settings to keep it on one page.
OK thanks for advising and assisting again.I'm puzzled, too. Seems that aesthetics (form) is coming before function, which is like putting the cart before the horse.
It appears that the long used grid format hasn't been a good idea. It has been used for centuries.
Grid format is fine - nothing wrong with that. Just let the columns be as wide as they need to be.
OK thank you.
It may be time to retire.
Let's say your formula is this...Originally Posted by Un-Do Re-Do
=A3/B3
simply change the formula to this...
=TEXT(A3/B3,"General")
You should be able to do something similar with whatever your actual formula is.
Last edited by Rick Rothstein; 06-24-2021 at 05:04 AM.
Thanks for looking into.
Yes I did consider that but will have to use the values in future calculations.
So that means a lot of work to convert number to strings and vice versa all the time.
I don't think the Text format could be used as a reference in the next formula, I could be wrong though.
Can you show us what you are trying to achieve/avoid on a more realistic sheet??
You will still be able to use the outputted text number in mathematical operations as Excel will automatically convert the text number to a real number in order to use it in a mathematical operation.
Yes you are right.You will still be able to use the outputted text number in mathematical operations as Excel will automatically convert the text number to a real number in order to use it in a mathematical operation.
It wasn't working for me as I had formatted the cell using the right-click menu and chosen "Text". But with your formula method it appears too work.
Thanks for that.
See attachment.Can you show us what you are trying to achieve/avoid on a more realistic sheet??
At the moment I am merging cells.
I used the Sum function on merged cells recently and got 3 times the value expected.
So I'm trying to stop merging cells.
Snapshot2.png
Can't do much with a non-editable picture of a spreadsheet. Attach the Excel file.
It has been answered now.
What was the answer?
As per post 13.
Thanks for letting us know.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks