decimal point

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to be able to type 1 and display .01, then type 1. and get 1.00
How do I accomplish this?
 
Tools>Options>Edit, check Fixed decimal and make the number of decimals 2.
Format your cells accordingly.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I change a number from 700.00 to 70000 without having to re 3
Sum If multiple conditions 3
Conversions of Decimal Feet to Decimal Inches - Formula?? 0
how do I automatically insert a decimal point? 1
search for text then add 3
Have Excel Enter Decimal Place 2
XIRR function providing incorrect results 4
Complex matching with ranges 1

Back
Top