| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I recover text that was truncated/ deleted in Excel? | Excel Discussion (Misc queries) | |||
| item numbers in a list that update if a row is deleted | Excel Discussion (Misc queries) | |||
| If No is deleted in middle of sequence,Nos alter after deleted No | New Users to Excel | |||
| conditional formating colours to stay when numbers are deleted? | Excel Worksheet Functions | |||
| automatically adjust numbers in a column when data is deleted | Excel Worksheet Functions | |||
Linear Mode
