Jump to content

Format cells as you type


Recommended Posts

Format cells as you type

Instead of going back to format cells after entering data, use these tips to configure Excel to format the cell as you type.

To enter a value in Currency format, type a dollar sign [$] before the value. For example, type $10.00 to enter 10 dollars in Currency format. (Don't confuse the Currency format with the format generated by the Currency button on the Formatting toolbar, which formats the cells in Accounting format with a dollar sign.)

To enter a value in Fraction format, type 0, press the spacebar, and type the fraction (including the slash). For example, typing 0, pressing the spacebar, and typing 1/2 enters one-half in Fraction format.

To enter a value in Percentage format, type a percent sign [%] after the value, as in 70%.

You can also format cells as text as you type. For example, if you enter the ZIP code value 08053, Excel formats it as the number 8053 by default. To configure Excel to format it as text, enter an apostrophe ['] before the value. In this case, typing '08053 formats the cell as the text value 08053.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...