| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Converting a number to 2 decimal places
I would like to be able to type a number into a cell and have it automatically converted to a number with the last 2 numbers to the right of the decimal point. For example, if I typed in 1234, it would become 12.34. How can I do that? -- mattslav ------------------------------------------------------------------------ mattslav's Profile: http://www.excelforum.com/member.php...o&userid=24039 View this thread: http://www.excelforum.com/showthread...hreadid=376481 |
|
#2
|
|||
|
|||
|
ToolsOptionsEdit Check Fixed decimal places Set for 2 Does that help? Ron -- Ron Coderre ------------------------------------------------------------------------ Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419 View this thread: http://www.excelforum.com/showthread...hreadid=376481 |
|
#3
|
|||
|
|||
|
Yes, that is exactly what I want. Thanks. -- mattslav ------------------------------------------------------------------------ mattslav's Profile: http://www.excelforum.com/member.php...o&userid=24039 View this thread: http://www.excelforum.com/showthread...hreadid=376481 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| decimal places within a formula | Excel Discussion (Misc queries) | |||
| I want to format a number cell without the decimal and without ro. | Excel Discussion (Misc queries) | |||
| Changing default decimal places | Excel Discussion (Misc queries) | |||
| How do I change the number of decimal places displayed in Excel | Excel Discussion (Misc queries) | |||
| Entering numbers with variable decimal places. | Excel Worksheet Functions | |||
Linear Mode
