topic Re: data in excel in BackOffice Products

data in excel

aditya_5 — Sat, 29 Jun 2002 23:21:30 GMT

hi,
Why is that numbers in excel appear to one end ( right) and text to the other end(left).
-adi

Re: data in excel

Patrick Wallek — Sat, 29 Jun 2002 23:28:13 GMT

That is called "Justification" either right or left. Right justified text will line up towards the right of the cell. Left justified will line up at the left of the cell.

You can control this by right clicking on a cell (or row number to format an entire row, or column heading to format an entire column) and choosing the "Format Cells" option. Once you are there choose the "Alignment" tab. From here you can control the horizontal and vertical alignment of data in a cell.

I'd suggest you buy a book on MS Office Suite and go through it.

Re: data in excel

steven Burgess_2 — Sat, 29 Jun 2002 23:32:00 GMT

Patrick

Where dooo you pick up all this information ?

Steve

Re: data in excel

Patrick Wallek — Sun, 30 Jun 2002 00:26:31 GMT

I've just been using the stuff for a while, Steven. No real magic or anything, just learned by using the stuff.

And I've never been afraid to try something to see what it does. If it messes up my spreadsheet or something, I'll just bring up the saved copy and start again.