in excel how do i get 1.23 when i enter 123

J

jacsells

how do i get the decimal point to enter automatic when i enter 123 and i want
1.23 without entering the decimal point manualy?
 
C

Chip Pearson

Go to the Tools menu, choose Options, then the Edit tab. There,
check the "Fixed decimal" option and enter 2 for the number of
places.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
P

Peo Sjoblom

Tools>options>edit and fixed decimal, set it to 2
don't forget to turn it off afterwards
 
J

jacsells

Thanks, When I want to go to whole numbers, 123 do I have to go back to
tools, options, edit and remove the fixed decimal check?
 
J

jacsells

Thanks, when I want to go back to whole numbers do I need to go back to
tools, options, edit and remove the fixed decimal check?
 
G

Gord Dibben

Yes.

You could leave that Fixed Decimal Places unchecked and use sheet event code
to divide your entries by 100 as you enter them.


Gord Dibben Excel MVP
 

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

Excel does not accept text format! 0
formatting negative numbers 1
position of decimal point when entering a number ... 4
Auto Fill Word Documents 4
Decimal settings in access 07 3
Folder structure in teams channel. 0
How to count the numbers in a Word document? 0
How to Import Formatted text as new Slides in PowerPoint 0

Top