Dotan Cohen wrote: > More likely, the text may have been copy/pasted out of an email. Are > you suggesting that the data that was pasted was already rounded? I > will look into that possibility.
I had something odd happen to some imported data yesterday. It was formatted as numbers but I saw it was left-justified with leading blanks in the cells instead of the usual right-justified. When I clicked on a cell, the value on the input line of the toolbar appeared with a leading single quote. I fixed this by transferring the data to another sheet by multiplying each cell by 1.0. Another frequent problem I encounter with sheets where data is added/inserted is that although a check on the formatting for a row/column says one thing, that may not be true for all cells - some may have had other formats imported with the data. The cure I apply for that is to change the format for the row/column to something different, date format say, then back to the required format. What I'm saying is that I'm agreeing that the original importing could be at the heart of the problem. I assume you've looked at the data as it shows up in the input line? Sorry in advance if the foregoing appears like I'm teaching my grandmother to suck eggs. -- Graham P Davis, Bracknell, Berks., UK. E-mail: newsman not newsboy "I wear the cheese. It does not wear me." --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
