How do I input 2525 to display 25.25
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.
Ferdy wrote:
I want to create a spreadsheet that will accept numerical input and display
with 2 decimal places as in subject line
--
Dave Peterson
|