When i'm doing stuff on e-bay, I sometimes do a temp chart of the stuff i'm buying &/or selling, in Excel. In the first column I put the item number (in this case the other columns don't matter) If I cut'n'paste the number from e-bay, it dosn't come out quite right, until I format it as a single large number with no decimal places. So far - so good ! The trouble is, that I can't format the whole column to do it ! In all other columns, & highlight as much column as I want & format it accordingly. For eg: 200188832082 comes out as: 2.00189E+11.
the ' when entered as the first character in a cell forces Excel to display and treat all the following characters as text, whilst not displaying the '. It is very handy when Excel auto-formats things, such as dates.
For example entering November 2007 is often auto-formatted to Nov-07. Entering 'November 2007 is not auto-formatted and is displayed as November 2007.
This thread is now locked and can not be replied to.