Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Greetings.
I have very small cells in a sheet that I use for printing. One technique that I use us to put data into a cell which sits to the left of a line and turn on the right justify in the properties menu. This then pushes the test to the right and over any empty cells to the right. This was working until I tried to do the same thing with currency. The column width is .69 and as this size the only way I can view anything is with this spill over. If I type in text the spill over works. If I increase the width the currency is there and forced right as it is supposed to be. Yet when I return the column to it's .69 size, it disappears. Does anyone have any idea as to what is causing this and how to fix it, sort of changing column widths (not an option in this case)? Any help would be most appreciated. TIA -Minitman |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to change default cell format to "Text" | Excel Discussion (Misc queries) | |||
Format text in one cell based on value in another cell | Excel Worksheet Functions | |||
format a text cell in Excel | Setting up and Configuration of Excel | |||
format cell from data input to output form | Excel Worksheet Functions | |||
Format Number to Text | Excel Worksheet Functions |