numbers convert to text??

J

JR Hester

Arh! Excel '07 on WinXP
Just found this one yesterday on 2 machines.

Spreadsheet created in Excel XP. Obne cell formatted as percentage with 2
decimal places. Attempt to enter 12.24%, hiowever as soon as teh period is
entered, the "12" becomes "twelve" and cell will not acept the remaining
digits-- the "24" following the period. I checked the formatting-- still set
to percentage with 2 decimal places.

Any ideas on this one?

Thanks in advance fro your help!
 

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

Converting decimal degrees to degrees, minutes & seconds 2
Excel 2003: Cell rounds 16 digit numbers- How to advoid rounding? 1
tiny discrepancies in fixed-point numbers 3
General Format altered/corrupted? 1
Automatically chnage number format of a range of cells 2
How do I prevent the cell from changing the number I enter? 2
decimal places 2
Find/Replace Numbers stored as Text drops zeros 1

Top