excel .txt to .cvs, lose trailing zeroes in numeric field

S

stevefromatlanta

After I save an Excel .txt file as a .cvs file, I lose trailing zeroes in
monetary fields. Example: 320.50 is saved as 320.5 and 321.00 is saved as 321.
How can I save a file as a cvs and keep the monetary fields as is?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add additional information to excel form after original data entry 0
Read Only now different 1
convert to cvs(,) from excel 4
converting txt and cvs files 1
How can I save directly into the same folder every time in Office 365 / Windows 10? 0
Import data from Excel into Outlook journal 1
csv format is wrong in Denmark 3
Reading CSV with numbers in text format, Excel automatically convertsto scientific notation 1

Top