Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Hi,
I have just exported some data in a table from an sql file to Excel and have noticed that some of the figures in the column have a small green triangle next to it with the message, 'it is formatted as text or has an apostrophe in front of it'. What does this mean? I am trying to change a column of 0's to 1's then import it back into sql, but after replacing the 0's with 1's, find that some have this triangle. I have searched the help files but can't find anything to help me. Thanks Rock |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to count the number of text frequencies and copy to other cell | Excel Worksheet Functions | |||
Change number in Text Box in Excel | Excel Discussion (Misc queries) | |||
edit number in cell without it changing to text | Excel Discussion (Misc queries) | |||
Format Number to Text | Excel Worksheet Functions | |||
16 digit number wont keep alteration unless format cell to text | Excel Discussion (Misc queries) |