View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JR Hester JR Hester is offline
external usenet poster
 
Posts: 170
Default numbers convert to text??

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!