> -----Original Message----- > From: WAMUG Mailing List [mailto:[EMAIL PROTECTED] Behalf Of Bob > Howells > Sent: Monday, 8 September 2003 4:20 PM > To: WAMUG Mailing List > Subject: Re: Who knows Excel ? ANSWER: > > > THANKS TO THOSE WHO REPLIED... ONNO & Andy. > > Oh what a tale we weave ........ ? > > Some of my numbers were numbers with number Values > And then some looked like numbers but were TEXT without a number value. > > So of course they sort differently. > > To tell the difference.. Try an "autosum" > The ones with values will sum to whatever figure > The ones with Text value will sume to 0, that's zero. > > There is probably a way in excel to convert from text to value, > But All I have found so far is converting value to text. > > One way to handle the situation is to save the file as "text", > That's plain text & not a Word doc. > > Then reimport into excel using the :- > > Data _ Get external Data - Import text file....... > > function to finally save the imported information as Excel data. > > > Have fun > > Bob
Another way to fix, is to select and highlight all the cells in question, and copy into a text editor (using <ctrl> x and <ctrl> v) then select in text editor and paste back into excel. I use notepad on a pc to do this, I would use something like simple text or equiv. on a Mac. Then it looses all formatting :o) Regards, Kat. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.443 / Virus Database: 248 - Release Date: 10/01/2003
