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 |
Formatting problem
You must have conditional formatting going on there because thats not normal behaviour for a standard formatted column. -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=36900 |
All times are GMT +1. The time now is 01:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com