Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formatting problem tadly Excel Worksheet Functions 4 October 9th 08 11:33 AM
formatting problem Beth[_2_] Excel Discussion (Misc queries) 3 July 30th 08 03:39 AM
Formatting Problem MET Excel Discussion (Misc queries) 4 March 6th 08 04:43 PM
Formatting Problem ROY WAITE Excel Programming 0 December 3rd 07 11:36 AM
formatting problem srv5uk Excel Discussion (Misc queries) 1 July 7th 05 07:28 PM


All times are GMT +1. The time now is 11:03 PM.

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

About Us

"It's about Microsoft Excel"