ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do i align numbers (https://www.excelbanter.com/excel-discussion-misc-queries/111054-how-do-i-align-numbers.html)

chikaya

how do i align numbers
 
why i can align text and i cant alkign numbers even if i format numbers as
text? can anyone help?

Bernard Liengme

how do i align numbers
 
Type 123 in a cell and click the left align icon on the menu bar. What
happens?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"chikaya" wrote in message
...
why i can align text and i cant alkign numbers even if i format numbers as
text? can anyone help?




chikaya

how do i align numbers
 


i had a table in excel with many numbers in it and i couldnt align those
numbers but when i copied this table to a new book i could align the numbers
howewer i wanted to.
i have no idea why i couldnt align them in first book

Tom Hayakawa

how do i align numbers
 
It's possible the numbers in the old book had spaces entered after them.
That would keep them from aligning properly.

"chikaya" wrote:



i had a table in excel with many numbers in it and i couldnt align those
numbers but when i copied this table to a new book i could align the numbers
howewer i wanted to.
i have no idea why i couldnt align them in first book



All times are GMT +1. The time now is 04:35 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com