UNSOLVED
MS Excel
Hello All!
I m having an issue with alignment of text in Excel 2003.
I would enter a column of numbers, and then highlight the column. I then press , then go to 'alignment' and change the settings.
However, for some reason the settings only apply to some of the cells in the column, not all of them! Even using the shortcut icons on the toolbar doesn't work either. I m puzzled...
What's going on?
Message Edited by doanster on 06-30-2005 10:16 AM
247
0
Posted June 30th, 2005 17:00
Hmm... I highlighted the whole column, then changed all of them to the same format. Still no luck tho :s
thx for the help neway
247
0
Posted June 30th, 2005 17:00
Are you sure all the numbers (cells) have the same format? For example, if some cells are formatted as "number" or "currency" but others are set as "accounting", they won't align the same way. When formatted as "accounting", numbers always align flush-right, regardless of whether you select flush-left or center for that column/row.
Ron
247
0
Posted June 30th, 2005 19:00
It should be a green (looks black) triangle in the upper left. It indicates an error in the formula. Are there formulas in the cells?
doanster
173 Posts
247
0
Posted June 30th, 2005 17:00