2011 Excel Question for Mac

I'm having an issue with Excel 2011 for Mac. I just bought a bunch of labels from onlinelabels.com, and their templates have a 0.125 spacing between each label. I can't get that space width or height to work in excel. How can I get this to work? Are there any work around? Any fixes? Any way possible for me to make this work? Please someone help me. This is so aggravating.

Thank you.

asked Mar 18 '11 at 10:13

moose205
1●1●1●1

2 Answers:

oldest newest most voted

I am using Excel 2010 and got the rom and column to except the measurement just fine. Of course I'm using it on Windows 7 but that shouldn't matter. Make sure to adjust the rom height or column width that you highlight the entire element by clicking on the row or column header (the number or letter part). You can then right click on the number or letter and choose "Row height..." or "Column width..." and make you changes. Hope this helps.

answered Mar 18 '11 at 10:33

David
3.3k●11●20●62

I do that and it will only let me go to 0.12, or 0.13. There is no 0.### if that makes any sense. I'm wondering if this is a mac problem. Or is there a setting that I'm overlooking?

answered Mar 18 '11 at 10:35

moose205
1●1●1●1

It's not Mac. I just went through all of the settings and there's nowhere to make that adjustment. Basically it is rounding the measurement you're typing in. I have looked everywhere I can think of in excel to turn off that option and I can't find it. I typed in 30.125 and it rounded up to 30.14. 30.12 also ='s 30.14. You're best option may be to enter 0.4 to get as close as possible. I can't even get it to let me enter 0.5. It auto corrects to 0.4.

(Mar 18 '11 at 11:08) David

I was able to get it too 0.17 and that's it. The other option was 0.08.

(Mar 18 '11 at 11:09) David

Your answer

toggle preview

community wiki

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or __italic__
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown