Link to home
Start Free TrialLog in
Avatar of exoson
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
ASKER CERTIFIED SOLUTION
Avatar of Glenn Ray
Glenn Ray
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of exoson
exoson

ASKER

Thanks, that worked great.  I wasn't selecting and setting the text to the correct column.
Avatar of exoson

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.
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
Avatar of exoson

ASKER

Was the exact fix I was looking for.
Thanks!  Glad I could help; sometimes it's just a "forest/trees" thing.
Avatar of exoson

ASKER

Sorry about the screw up on the accept.  I was sure I did that, but it showed up as a comment instead.