A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

deleted text character returning numbers when deleted.



 
 
Thread Tools Display Modes
  #1  
Old April 10th, 2010, 01:55 AM posted to microsoft.public.excel.newusers
Trreborr09
external usenet poster
 
Posts: 1
Default deleted text character returning numbers when deleted.

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?
  #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?


  #3  
Old April 10th, 2010, 11:41 AM posted to microsoft.public.excel.newusers
Ron@Buy
external usenet poster
 
Posts: 348
Default deleted text character returning numbers when deleted.

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" 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?


  #4  
Old April 11th, 2010, 03:17 AM posted to microsoft.public.excel.newusers
ozgrid.com
external usenet poster
 
Posts: 328
Default deleted text character returning numbers when deleted.

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



--
Regards
Dave Hawley
www.ozgrid.com
"Ron@Buy" wrote in message
...
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" 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?



 




Thread Tools
Display Modes

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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:33 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.