Typing "12345" and have it automaticly formated to "123.45"?

Z

ZenTrickz

Does anyone know anything about formatting cells so they would behave
like an accounting calculator. As in typing "12345" without pressing
any decimal key, and have it use the last two digits as the tenth and
hundredth decimal place, ie) "123.45"?

If it isn't possible, it would be informative to know that as well.

Thanks a million in advance!
 
C

Chip Pearson

Go to the Tools menu, choose Options, then the Edit tab. There,
check the Fixed Decimals setting and choose the number of decimal
places you want (default is 2).


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


"ZenTrickz"
message
news:[email protected]...
 
R

Ron Coderre

Try this:

From the Excel main menu
<tools><options><edit tab>
Check: Fixed decimal
Set Places to 2

Does that help?

Regards,

Ro
 
C

Chip Pearson

I should have added that this changes the actual value of the
cell, not just the displayed value.


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

Corey

In any future cases, you might keep in mind that you can simply change
the formatting of the 'problem' cell. By right-clicking selecting
Format Cell, you can ensure that the cell you selected isn't set as a
date, currency, decimal, so on and so forth. Just FYI! Glad they
resolved the issue for you!
 

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

Formula function(s) to do this? Or is it a formula at all? 4
sum if based on cell forrmatting...is it possible and how to 2
How to Display 12.5 but not 25.0 (drop .0’s) 5
how to make my own classes show their methods and/or variables while typing? 5
Windows Explorer navigation changes from one form to another when typing without notice 3
how do I add new data and have it added to existing data 1
is it possibe to "defrag" and Excel data file? 2
Safe Mode restarts over and over after mobo change. 2

Top