Computers and Software > Computers and Software - General

Excel help

(1/2) > >>

Sbrem:
I don't really use spreadsheets much, and could use a little help. I created a .csv file from Quickbooks of our customer list to import into Printavo. A rep took our file and opened it up and rearranged it for us and sent it back for us to edit some more. In our geographical location, zip codes all start with a zero. Excel apparently removes those "leading zeroes" by default, so the file I got back has all of the zip codes with only 4 digits, missing the "0" in the front. Searching for an answer, I find that the trick is to format the column as text, so the automatic removal has no effect. OK, that makes sense, so I select that column, and format it as text, then I edited a dozen zip codes, and saved it, which wants to replace the original instead of just updating it, which I don't get, but fine, replace it. When I open it again, the formatting is gone, and so are zeroes I edited in. Heavy sigh...

Steve

inkman996:
I dont know if this will help since I use Open Office for everything. But when ever I import anything into excel that has leading zeros in columns when presented with import options I can select that column and change it to text. This then imports correctly and always retains it correctly. So maybe you need to start fresh with the import from QB and make sure you change the formatting as desired. Again I do not use excel but I do know the two are nearly exact in processes.

Sbrem:
That sounds reasonable, but I'm still perplexed about the Save thing not working...

Steve

aauusa:
this should help figure it out for you  https://www.ablebits.com/office-addins-blog/2017/01/18/add-leading-zeros-excel/#:~:text=Excel%20Number%20Format%20Leading%20Zeros%201%20Select%20a,Click%20OK%20to%20save%20the%20changes.%20See%20More.

Sbrem:

--- Quote from: aauusa on January 21, 2022, 12:09:01 PM ---this should help figure it out for you  https://www.ablebits.com/office-addins-blog/2017/01/18/add-leading-zeros-excel/#:~:text=Excel%20Number%20Format%20Leading%20Zeros%201%20Select%20a,Click%20OK%20to%20save%20the%20changes.%20See%20More.

--- End quote ---

That is helpful, even if it hurts my head a little. Printavo said they would check it out for me as well. What I don't see in the list is choosing multiple cells to convert from number to text, and add a 0 in front. It's either one cell or the whole column. But I'll test and see what I get. I think I figured out the saving problem, it's a .csv file, it has to be saved as an Excel file.

Steve

Navigation

[0] Message Index

[#] Next page