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


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 ayoubtt Excel Discussion (Misc queries) 0 March 18th 08 07:25 PM
Formatting problem PE&T Setting up and Configuration of Excel 1 February 22nd 06 10:20 AM
CSV formatting problem andyp161[_7_] Excel Programming 1 February 12th 06 12:22 PM
Formatting problem Henry Excel Discussion (Misc queries) 11 June 25th 05 01:20 AM
Formatting problem rfhorn Excel Worksheet Functions 0 April 8th 05 02:07 PM


All times are GMT +1. The time now is 05:57 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"