We've made cell formating changes so that the cents after the decimal point will be displayed, but after the file is closed and reopened 625.00 displays as 625 and 1725.20 displays as 1725.2
Has anybody come up with a solution for that?
2006-08-04 09:04:41 · 5 answers · asked by thisisnancyh 1 in Computers & Internet ➔ Software
Convert the 625 to text using '625.00 (note the single inverted comma). That way the csv will read it as 625.00
In other words format the number as text with the trailing two zeros
2006-08-04 20:49:01 · answer #1 · answered by Dilip Rao 3 · 0⤊ 0⤋
When you entered the values into the spreadsheet, did you actually type "625.00", or did you type "625" and let the spreadsheet convert it to "625.00". If the second, then you will get "625" when you make a csv, because that is the actual content of the cell, not "625.00".
2006-08-04 09:10:36 · answer #2 · answered by dewcoons 7 · 0⤊ 0⤋
A CSV file is plain ASCII text and cannot be formatted.
CSV stands for comma separated values. It's a text file that uses commas to separate the different fields.
2006-08-04 09:08:27 · answer #3 · answered by Anonymous · 0⤊ 0⤋
The comma-delimited format (.csv) for residing house windows is a popular converter put in with place of work. If that's not listed, then it exchange into throughout the setting up that the converter wasn't put in. flow to the upload/eliminate button in the administration panel, click on exchange for Microsoft place of work then on alter whilst it comes up. Left mouse click the "Converters and Filters" and choose "Run all from my computer" -- this could setting up each and all of the converters and filters.
2016-10-01 11:46:18 · answer #4 · answered by ? 3 · 0⤊ 0⤋
don't use csv (comma separated values). It's not designed to save formatting anyways.
2006-08-04 09:09:14 · answer #5 · answered by TxVarmit 3 · 0⤊ 0⤋