View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
WLMPilot WLMPilot is offline
external usenet poster
 
Posts: 470
Default Help to align FORMAT

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