View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Marc[_26_] Marc[_26_] is offline
external usenet poster
 
Posts: 14
Default Formatting problem

In my excel sheet there is a General formatted column
When entering numbers in to the column it stores as numbers with aligning
right side
Then I format the entire column as text, after that all values are left
aligned
Then I entered a new value in to the column, it stores with green colour
hyphen
Previously entered values are not like that. If I edit the previously
entered value then that value also stores with green colour hyphen.
What is the reason for this and how to avoid this
Please Help