exoson
asked on
How to prevent excel import from deleting trailing zeroes
I am having trouble with losing trailing zeroes on excel opens/imports using .csv files.
I have fields like 1.1, 1.8, 1.10, 1.11, 1.100.
When either opened by or imported to excel, it changes that to 1.1, 1.8, 1.1, 1.11, 1.1.
When I import I told it that the data was general or text and neither work.
Anyone know a way to keep the trailing zeroes?
Scott
I have fields like 1.1, 1.8, 1.10, 1.11, 1.100.
When either opened by or imported to excel, it changes that to 1.1, 1.8, 1.1, 1.11, 1.1.
When I import I told it that the data was general or text and neither work.
Anyone know a way to keep the trailing zeroes?
Scott
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I've requested that this question be closed as follows:
Accepted answer: 0 points for exoson's comment #a40099683
for the following reason:
Was the exact fix I was looking for.
Accepted answer: 0 points for exoson's comment #a40099683
for the following reason:
Was the exact fix I was looking for.
Hi Scott,
If my solution worked for you, please select it by clicking the small link titled "Accept as Solution" (in green text above and on the right side of my solution). You'll then be asked to grade it (A,B,C) and provide any comment if you wish.
Thanks; I'm glad I was able to help!
-Glenn
If my solution worked for you, please select it by clicking the small link titled "Accept as Solution" (in green text above and on the right side of my solution). You'll then be asked to grade it (A,B,C) and provide any comment if you wish.
Thanks; I'm glad I was able to help!
-Glenn
ASKER
Was the exact fix I was looking for.
Thanks! Glad I could help; sometimes it's just a "forest/trees" thing.
ASKER
Sorry about the screw up on the accept. I was sure I did that, but it showed up as a comment instead.
ASKER