How do I input 2525 to display 25.25

F

Ferdy

I want to create a spreadsheet that will accept numerical input and display
with 2 decimal places as in subject line
 
D

Dave Peterson

Tools|Options|Edit tab|
Check Fixed decimals and set it for 2.

Be aware that you'll have to change this back to what you want when you're done.
 
Top