ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Cell contents don't display everything entered? (https://www.excelbanter.com/excel-discussion-misc-queries/85080-cell-contents-dont-display-everything-entered.html)

treybreak

Cell contents don't display everything entered?
 
I am setting up a price list in Excel to match an existing list. This list
contains a description cell and a price cell. What I want to do is display
product for rental followed by periods and then the price for example:
Source Four 19°, 26°, 36°, 50°€¦€¦...€¦€¦€¦€¦€¦....€¦€¦€¦€¦€¦€¦ €¦€¦. $12
The problems are
1: the periods show up as differnt sizes on the sheet display and printed,
some show up looking like a cross between a period and a comma
2: If I add to many periods the 50° and all of the periods disappear
3: If I add to few commas the periods don't line up in a straight line at
the end of the descriptive column.
I'm entering at least four hundred items on this list, so I don't want to be
counting periods for each item. I just want to be able to enter the
description hold down period and have the price column mask any periods in
excess of the cell width for the descriptive column.
Please if anyone has any ideas let me know I've had this sheet done for a
couple of weeks now except for the periods working apreciatedfor me. Any
suggestions would be greatly appreciated!


All times are GMT +1. The time now is 04:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com