Pelican Parts Forums

Pelican Parts Forums (http://forums.pelicanparts.com/)
-   Off Topic Discussions (http://forums.pelicanparts.com/off-topic-discussions/)
-   -   Question about excel (http://forums.pelicanparts.com/off-topic-discussions/569243-question-about-excel.html)

126coupe 10-11-2010 03:36 PM

Question about excel
 
I am creating some spreadsheets and I am having a small problem.
I am centering some data in a cell and for some reason a few cells will not center.
the "centering" button on these cells is pushed, yet the data still goes to the right of the cell.

Thanks in advance

jyl 10-11-2010 03:41 PM

Check the format. Some formats always right justify. If numbers, use the format that the behaving cells have, or use with plain old numeric. I'm not so familiar with the other format types.

rattlsnak 10-11-2010 03:42 PM

right click on the cell and select format cell, then alignment, then center.

VaSteve 10-11-2010 03:43 PM

Try right clicking and use "format cells" rather than the button at the top. Maybe there's something else going on. Is it text or numbers? If text, may want to try the "clean" function under the text formulas. Maybe there's unprintable characters or a bunch of spaces some dingbat entered messing you up? I have seen people abuse excel and write letters in it to make it work with their letter head. (banghead)

126coupe 10-11-2010 04:12 PM

Thanks guys

holtjv 10-11-2010 04:50 PM

Accounting format will always right-justify (easier to visually add). Probably the number type, I'm guessing.


All times are GMT -8. The time now is 02:17 PM.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2025, vBulletin Solutions, Inc.
Search Engine Optimization by vBSEO 3.6.0
Copyright 2025 Pelican Parts, LLC - Posts may be archived for display on the Pelican Parts Website


DTO Garage Plus vBulletin Plugins by Drive Thru Online, Inc.