deleted text character returning numbers when deleted.

's Computer Specifications

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?

's Computer Specifications

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" <(E-Mail Removed)> wrote in message
news:699A8A13-7CD5-443A-BA17-(E-Mail Removed)...
> 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?

's Computer Specifications

ozgrid, I think you may have missed the "(" from the question.
I believe that there may be custom formatting applied to the cell.
Try changing the format to number with the number of decimal places you wish
to see.

"ozgrid.com" wrote:

> 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" <(E-Mail Removed)> wrote in message
> news:699A8A13-7CD5-443A-BA17-(E-Mail Removed)...
> > 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?
>

's Computer Specifications

Where is the open Parenthesis in relation to the number: 8212.0011

--
Regards
Dave Hawley
www.ozgrid.com
"Ron@Buy" <(E-Mail Removed)> wrote in message
news:0C5D6180-16E2-422C-8631-(E-Mail Removed)...
> ozgrid, I think you may have missed the "(" from the question.
> I believe that there may be custom formatting applied to the cell.
> Try changing the format to number with the number of decimal places you
> wish
> to see.
>
>
> "ozgrid.com" wrote:
>
>> 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" <(E-Mail Removed)> wrote in message
>> news:699A8A13-7CD5-443A-BA17-(E-Mail Removed)...
>> > 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?
>>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Deleted outbox message and deleted it from deleted items	=?Utf-8?B?QWxiZWFu?=	Microsoft Outlook Discussion	1	19th Dec 2006 02:12 PM
Why is template logo deleted when surrounding text is deleted?	=?Utf-8?B?c2NodmFnZXI=?=	Microsoft Word Document Management	1	20th Nov 2006 09:07 PM
When I type a character, the next character is deleted. Why?	=?Utf-8?B?QW1hbGdhbWFsaWE=?=	Microsoft Word Document Management	1	8th Dec 2005 12:02 AM
Deleted items keep returning to my deleted items folder	DSerum	Microsoft Outlook Discussion	0	31st Mar 2004 05:15 PM
can deleted ids be deleted from the deleted section of the messanger forever?	-=Ms Mehmud=-	Windows XP Messenger	0	12th Sep 2003 08:50 AM