| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Left Justify Cell
Can someone tell me how to programatically left justify a
cell. Actually, if all of the cells were left justified that would be even better. My problem is when my character data contains all numerics, the data is right justified. When the data contains at least one alpha character, it is left justified. This causes the work sheet not to look very nice. Thanks. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Left Justify Cell
Range("A1:C9").HorizontalAlignment=xlHAlignLeft
Use with any valid range. Keep in mind that certain number formats such as accounting can throw this off. Phil -----Original Message----- Can someone tell me how to programatically left justify a cell. Actually, if all of the cells were left justified that would be even better. My problem is when my character data contains all numerics, the data is right justified. When the data contains at least one alpha character, it is left justified. This causes the work sheet not to look very nice. Thanks. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Left Justify Cell
Have you tried recording a macro?
"Ron K" wrote in message ... Can someone tell me how to programatically left justify a cell. Actually, if all of the cells were left justified that would be even better. My problem is when my character data contains all numerics, the data is right justified. When the data contains at least one alpha character, it is left justified. This causes the work sheet not to look very nice. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to left-justify zero-filled cell Exl2007 | Excel Discussion (Misc queries) | |||
| Left Justify category axis | Charts and Charting in Excel | |||
| Right/Left Justify within a cell | Excel Discussion (Misc queries) | |||
| How do I left justify center section header | Excel Discussion (Misc queries) | |||
| left justify a legend | Charts and Charting in Excel | |||
Linear Mode
