Value keyed becomes divided by 100

  • Thread starter Thread starter jimian
  • Start date Start date
J

jimian

I'm using Excel2003.

On a new sheet I have a problem with entering values.

When an integer is keyed it becomes n/100

eg 34 <enter> becomes 0.34

but =34 <enter> gives 34

and 34.0 <enter> gives 34

Also any calculation entry appears correctly

It looks as though there is a default format that I don't know about.

I'd be delighted if someone could help.

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software! Free Support at
http://www.ozgrid.com/forum/ **
 
Go to the Tools menu, choose Options, then the Edit tab. There,
uncheck the "Fixed Decimal" setting.


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

Try:

Tools | Options | Edit | Uncheck the Fixed Decimal Places option
 
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

Excel Time Problem 2
How do I parse for fields separated by a carriage control within a cell? 1
auto-hyperlinking worksheet but also showing a cell value beside it 1
format row on cell value loop 2
How to convert Dollars & cents from numbers to words? 2
Pivot Table 1
Sum cells flagged by other cells 2
User Defined Function 5

Back
Top