Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting problem
Marc,
This is Excel telling you that you have numbers stored as text. To get rid of the green triangle:- Tools|Options - Error Checking tab - Un-check 'numbers stored as text' Mike "Marc" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting problem
Thanks Mike
But the problem is already there "Mike H" wrote in message ... Marc, This is Excel telling you that you have numbers stored as text. To get rid of the green triangle:- Tools|Options - Error Checking tab - Un-check 'numbers stored as text' Mike "Marc" wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting problem
To fix existing cells, selec them and run:
Sub marc() For Each r In Selection With r .NumberFormat = "General" .Value = .Value End With Next End Sub -- Gary''s Student - gsnu200817 "Marc" wrote: Thanks Mike But the problem is already there "Mike H" wrote in message ... Marc, This is Excel telling you that you have numbers stored as text. To get rid of the green triangle:- Tools|Options - Error Checking tab - Un-check 'numbers stored as text' Mike "Marc" wrote: 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting problem
Thanks Gary
But my entire column is formatted as Text According to your code it is formatted in to General I want to keep the column in Text format and make every cell value in to text "Gary''s Student" wrote in message ... To fix existing cells, selec them and run: Sub marc() For Each r In Selection With r .NumberFormat = "General" .Value = .Value End With Next End Sub -- Gary''s Student - gsnu200817 "Marc" wrote: Thanks Mike But the problem is already there "Mike H" wrote in message ... Marc, This is Excel telling you that you have numbers stored as text. To get rid of the green triangle:- Tools|Options - Error Checking tab - Un-check 'numbers stored as text' Mike "Marc" wrote: 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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting problem
When you select a cell with a green arrow you can use the mouse to highlight
a dropdown box. Among the options are Ignore this error (numbers stored as text). When you click ignore the arrows will disapear. save the file and when you reopen there will be no more error messages. Peter Atherton "Marc" wrote: Thanks Gary But my entire column is formatted as Text According to your code it is formatted in to General I want to keep the column in Text format and make every cell value in to text "Gary''s Student" wrote in message ... To fix existing cells, selec them and run: Sub marc() For Each r In Selection With r .NumberFormat = "General" .Value = .Value End With Next End Sub -- Gary''s Student - gsnu200817 "Marc" wrote: Thanks Mike But the problem is already there "Mike H" wrote in message ... Marc, This is Excel telling you that you have numbers stored as text. To get rid of the green triangle:- Tools|Options - Error Checking tab - Un-check 'numbers stored as text' Mike "Marc" wrote: 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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting problem
A one line change!
Sub marc() For Each r In Selection With r .NumberFormat = "@" .Value = .Value End With Next End Sub -- Gary''s Student - gsnu2007k "Marc" wrote: Thanks Gary But my entire column is formatted as Text According to your code it is formatted in to General I want to keep the column in Text format and make every cell value in to text "Gary''s Student" wrote in message ... To fix existing cells, selec them and run: Sub marc() For Each r In Selection With r .NumberFormat = "General" .Value = .Value End With Next End Sub -- Gary''s Student - gsnu200817 "Marc" wrote: Thanks Mike But the problem is already there "Mike H" wrote in message ... Marc, This is Excel telling you that you have numbers stored as text. To get rid of the green triangle:- Tools|Options - Error Checking tab - Un-check 'numbers stored as text' Mike "Marc" wrote: 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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formatting problem | Excel Discussion (Misc queries) | |||
Formatting Problem | Excel Discussion (Misc queries) | |||
Formatting Problem | Excel Programming | |||
CSV formatting problem | Excel Programming | |||
formatting problem | Excel Programming |