Decimal masks

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

Guest

I would like to build a mask that allows me to enter a number without entering a decimal place. Example: enter 1045 in cell and see 10.45 It should work like the special formats for zipcodes.
 
Tools>Options>Edit tab>*enter a number in the Fixed Decimal Places and check
the box*>OK.

--
Greeting from the Gulf Coast!
http://myweb.cableone.net/twodays
John said:
I would like to build a mask that allows me to enter a number without
Click to expand...
entering a decimal place. Example: enter 1045 in cell and see 10.45 It
should work like the special formats for zipcodes.
 

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

Fixed decimal places in Excel 4
fixed decimal formatting 2
Excel 2003: Cell rounds 16 digit numbers- How to advoid rounding? 1
Excel 2007 adding a column of negative and positive number 2
Input masks 4
Access stripping decimal places in query 1
Input masks 1
Inserting decimal 6

Back
Top