PC Review


Reply
Thread Tools Rate Thread

deleted text character returning numbers when deleted.

 
 
Trreborr09
Guest
Posts: n/a
 
      10th Apr 2010
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?
 
Reply With Quote
 
 
 
 
ozgrid.com
Guest
Posts: n/a
 
      10th Apr 2010
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?


 
Reply With Quote
 
Ron@Buy
Guest
Posts: n/a
 
      10th Apr 2010
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?

>

 
Reply With Quote
 
ozgrid.com
Guest
Posts: n/a
 
      11th Apr 2010
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?

>>


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:50 PM.