Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Cindy
Lv 4
Cindy asked in Computers & InternetSoftware · 1 decade ago

help with Excel 2007 column width?

I have an assignment where i have to do several things to a sheet and one that is really irritating to me is "change the column width to 7.8" ok so i clicked on column A and it selected the whole column then i right clicked and clicked on column width and the column width display box popped up, i entered 7.8 and hit ok. but when i check the column width it says 7.86.

why is that and how can i get it to 7.80? i want to be precise because my professor is very strict about her measurements

i tried several times and it keeps saying its 7.86!

Update:

yea i tried adding 7.80 but it doesn't work either, i tried "10.56" just to check if it would do the same thing and it just went to like 10.50 or something like that.

2 Answers

Relevance
  • 1 decade ago
    Favorite Answer

    Really, don't worry about it. You have set a specific column width which is what you were asked to do.

    The column width is not a ruler measurement. It is actually based on the number of characters that can be entered in a cell using the default text style. To set it to 7.8 you would first have to find a font and font size that would exactly fit that size, then you would have to set the default style! Far too complicated.

  • Anonymous
    1 decade ago

    7.86 means that it is 7.8 and a 1/2 so he probably wont notice.....but if you really want it type 7.80

Still have questions? Get your answers by asking now.