Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I use a commandbutton to display gross pay of the current payperiod for two
part-time jobs. It takes three lines and for the most part, everything lines up. Problem is if the length of one amount is different than the other, then they do not line up. Example: $98.00 will not line up with $135.00 since one has 3 numbers to left of decimal and the other is only 2 numbers to the left. I tried FORMAT(amt,"##0.00") and FORMAT(amt,"000.00"). The amounts will not be greater than $999.99. What format can I use to insure columns line up? Thanks, Les |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Worksheets are stuck on default text format with left align | Excel Worksheet Functions | |||
format cell: right align with indent | Excel Discussion (Misc queries) | |||
Format and Align Columns | New Users to Excel | |||
Accounting format does not align decimals. | Excel Discussion (Misc queries) | |||
Format numbers so they align | Excel Discussion (Misc queries) |