ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Help with automated size in cells and two lines (https://www.excelbanter.com/excel-discussion-misc-queries/129687-help-automated-size-cells-two-lines.html)

ElFrodo

Help with automated size in cells and two lines
 
Hello helpful people.

I wonder if there is someone who can help me again. Im quit new to Excel
and maybe to ambitious about what I wane do. But anyway, this is my question.

I have a lot of cells that have size 12, as is should be, because I only
need rooms for 1 or 2 letters / numbers. But occasionally I need rooms for
i.e. 10.00-18.30. Then I need the cell to automatically changes capitol
size to 8 and to write in two lines in the same cell. Like this.
10.00
18.30


Is there some way to do this using a formula or setting??

Appreciate any help.

Kind regards from Norway:)



All times are GMT +1. The time now is 03:13 PM.

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