User Tools

Site Tools



commands I came across

command description
  • excel.exe /s
  • excel.exe /safe
start excel in safe mode.
excel.exe /autumation do not automatically open files and do not auto-run macros.


sum values based on another column


will compute sum(D2:D21) where F2:F21 are N and E2:E21 are Y.


See also:

concatenate with a delimiter

This will combine B3, C3 and D3 with '_' as the delimiter.


format dollars

To put the dollar sign on the left and right justify the number, use the custom format

_($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@_)


To only show the dollars (but not cents)

_($* #,##0_);_($* (#,##0);_($* "-"??_);_(@_)

tags | dollar sign left justified

excel_notes.txt · Last modified: 2022/01/31 17:01 by raju