• In Design View, right click on the cell you want to format, then right click "Text Box Properties". Click on "Number" tab and select the correct formatting.

    Quick tip, if you need to format multiple cell with the same format, then format one cell first as described above, left click on the formatted cell again and look at properties window, and then "Format" value. It would have a string, for example, currency would be like '$'#,0.00;('$'#,0.00). Copy the string/value. Highlight other cells you need to format by holding "Ctrl" and then go in properties again and paste the string/value into "Format" property again. Done, quick. Took me couple of year to figure this trick out.

    ------------
    🙂