Excel Number Formatting


R&J
 

When you key digits into an Excel cell, they are formatted as arithmetic numbers.  If you key an apostrophe "'" first, followed by the digits, they are formatted as text.

You may then highlight the cells in question, press ctl+1 to bring up the format menu, move to the alignment tab, and modify the horizontal, vertical and word-wrap settings accordingly.  This menu also allows you to alter the font, borders, numeric formats, fill or shading patterns and cell protection.

Hope this helps.  Ron




Avast logo

This email has been checked for viruses by Avast antivirus software.
www.avast.com


Join main@jfw.groups.io to automatically receive all group messages.