I need a function that serves the same purpose as the intrinsic VB Format function but with slightly different behavior.
Specifically, when the format string is "$ #,###,##0.00" and the value is 1.00 then the formatted result is "$ 1.00"
VB would give me "$ 1.00"
I need a fully justified string so that my columns line up correctly. I'm looking for a easy solution other than writing my own Format or Justification function.