View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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