Is there a way to set 2 decimal places in a cell without typing the (.) actual decimal?

**JKRIESEL** · 12-29-2013, 08:14 PM

Is there a way to format or set a formula to a cell to where it automatically inserts a decimal between 4 numbers.
I want to type say 3154 without typing the decimal and the cell automatically read 31.54. Is this possible? Thanks

**martindwilson** · 12-29-2013, 08:17 PM

excel options,advanced /automatically insert 2 decimal places

**JKRIESEL** · 12-29-2013, 08:37 PM

Thank you very much!

Is there a way to set 2 decimal places in a cell without typing the (.) actual decimal?

LinkBack

Thread Tools

Rate This Thread

Display

Is there a way to set 2 decimal places in a cell without typing the (.) actual decimal?

Re: Is there a way to set 2 decimal places in a cell without typing the (.) actual decimal

Re: Is there a way to set 2 decimal places in a cell without typing the (.) actual decimal

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] copy number with 3 or more decimal places and paste the actual value as 2 decimal number

[SOLVED] Calculating decimal places in a non decimal format (ie sixes not tens)

Paste two decimal number in excel without extra decimal places appearing

Removing decimal point while maintaining # of decimal places

FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT.

Bookmarks

Bookmarks

Posting Permissions