James Knott wrote: > Rick Bilonick wrote: >> On Tue, 2008-05-06 at 10:46 -0400, James Knott wrote: >>> Rick Bilonick wrote: >>>> I have a spreadsheet with numbers like 71.08929399 which when save end >>>> up to be 71.09. I need to save all numbers in the exact precision in >>>> which they are stored. I'm using OOo 2.3 (Red Hat). I don't see any >>>> options to force this. >>> You can set up to 20 decimal places for a number. Is that >>> sufficient? Also, if you're not doing calculations with that number, >>> you could use the text format. >>> >> >> The number 71.08929399 is what is actually in the .xls spreadsheet but >> only 2 decimal places display in the cell. When I save the spreadsheet >> to a .csv file, only 71.09 is saved. I want to always and automatically >> save the full precision to the .csv file (otherwise I'm inadvertently >> changing the contents). You say I can save up to 20 decimal places but >> you give ABSOLUTELY NO INFORMATION on how to do it. > > When you format a cell or column, you choose "number". On that panel > is a spin box, where you can select the desired number of decimal > places. When you save to CSV, it will included the specified number > of decimal places. >> >> Using text format makes no sense. The data comes in a spreadsheet with 2 >> decimal places formatted for display. I want to keep ALL the real >> precision when saving to .csv. I don't want to round or truncate when >> saving to .csv. I can change the format for viewing but that is a real >> pain plus it makes viewing the spreadsheet difficult. There must be some >> way to force Calc to save all numbers with complete precision. I've >> looked through all the options and tried changing some but nothing I've >> done so far does the trick. > > Text formatting often makes sense, depending on what you're doing with > the data. If you want to have a free form number, that would be what > you'd use. Without knowing your requirements, I have no way to know > if it would be suitable or not. I was simply offering it as a > possibility. As an experiment, try saving both as a number, with a > fixed number of decimal places and also as text. You'll find the > fixed number of decimal places will result in some trailing zeros, if > you don't use all the places. On the other hand, text will save the > string exactly as you entered it, but with the addition of quotes. > Which is better for you, depends on what you do with the data. > > >
Hi all, I have a case where numbers are used in a text format of xxxxxxxxxx (10 characters), that should be converted to xxx.xxx.xxxx (10 characters in groups of 3, 3 and 4 separated by a dot) The characters should be text, but using numbers; e.g. 001.002.0003 as a part number for a machine. In an exported CSV file there is a number of e.g. 0010020003 without the dots. The export was from a database that could not accommodate the numbers with the dots, because the fields were limited to 10 characters. I now need to format the cells as text (for CSV) with dots added, to import into a new database. When I use @###.###.#### it just adds ###.###.#### behind the number, e.g.: 0010020003###.###.####. I have tried various work-around's with numbers to text etc. What I need is to convert 0010020003 to 001.002.0003 as text. Any help appreciated. TIA Al --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
