A
Alan T
I have text, say, 123 456 will alignment to the right.
However, if I have 123 456/1, it will align to the left.
How do I align both to right?
However, if I have 123 456/1, it will align to the left.
How do I align both to right?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Roger Govier
Hi Alan
What you have typed has a space between the 3 and 4. I assume that is a
typo, as the space would make it a text value and it would align left.
In answer to your question, mark the range of cell concerned and click
the format Right icon on the toolbar
What you have typed has a space between the 3 and 4. I assume that is a
typo, as the space would make it a text value and it would align left.
In answer to your question, mark the range of cell concerned and click
the format Right icon on the toolbar
S
Stan Brown
Thu, 31 May 2007 17:51:27 +1000 from Alan T
Format ... Cells ... Alignment ... Horizontal
There's also a little icon for right justification in the Formatting
toolbar, if I recall corectly.
I have text, say, 123 456 will alignment to the right.
However, if I have 123 456/1, it will align to the left.
How do I align both to right?
Format ... Cells ... Alignment ... Horizontal
There's also a little icon for right justification in the Formatting
toolbar, if I recall corectly.
D
Dave Peterson
If you want to treat all the values as text (left aligned), either preformat
your cell(s) as Text, then do the data entry.
Or start with a leading apostrophe: '123 456/1
When I typed 123 456/1 in a cell with a general format, excel saw it like I was
typing in a mixed number (a whole number + a fraction (in this case an improper
fraction 456/1).
Excel changed my entry to 579.
If I wanted to enter 3.5, I could type:
3 1/2
(including the space)
and excel would know/guess that I meant a number.
your cell(s) as Text, then do the data entry.
Or start with a leading apostrophe: '123 456/1
When I typed 123 456/1 in a cell with a general format, excel saw it like I was
typing in a mixed number (a whole number + a fraction (in this case an improper
fraction 456/1).
Excel changed my entry to 579.
If I wanted to enter 3.5, I could type:
3 1/2
(including the space)
and excel would know/guess that I meant a number.