View Single Post
  #2  
Old April 10th, 2010, 02:48 AM posted to microsoft.public.excel.newusers
ozgrid.com
external usenet poster
 
Posts: 328
Default deleted text character returning numbers when deleted.

8212.0011 is numeric and not text. You say are deleting a text character
from 8212.0011? What text character?



--
Regards
Dave Hawley
www.ozgrid.com
"Trreborr09" wrote in message
...
why would a value in a cell as shown here 8212.0011( return a value of
8212.00110000.00 when the ( character was deleted from the cell? The
version
of excel is 2007 and the os is XP. Is there a regional setting controlling
this?