2009/7/2 Graham P Davis <[email protected]>: > 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. > >
Thanks. I have the original email where one of the rounded numbers was copy/pasted from and the number is not rounded in the email. -- Dotan Cohen http://what-is-what.com http://gibberish.co.il --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
