Leading Zeroes

[kenneth2k1]

Hello all:

Ok, this question is not about FM, it's about Excel.

I have three fields in my FM file for phone number. I am going to import recs from an excel spreadsheet into it. The phone nums are in 1 column. So I did text to columns/fixed width and parsed it into three columns. But it keeps stripping out the lead zeroes. I checked everything, does any know EXACTLY where to go and change this?

Thanks

Ken

[Lee Smith]

Have you tried formatting your Excel Cell as Text?

If not, select the columns and in the Excel Menu - Format - Cell - Text.

HTH

Lee

[kenneth2k1]

Lee:

Thanks for the reply. But I tried it. I tried just about every format that was in there.

Ken

[Lee Smith]

Hi Ken,

I just save a file in two different formats, with a text field with 00001234 in it, Excel drops the 0000 if the file is open as text, but opens the file if saved as WKS file directly and ghe 0000 are still in front of the 1234.

HTH

Lee

[kenneth2k1]

Hi Lee:

Thanks for helping. I'm not sure I follow you last post. Did you open the file with Excel or 1-2-3? I tried saving it as a .wks and opened it with excel (cells formatted as text, and I tried general format) and the same problem still occurred. I have Excel 2002 (win). I am sure that I must be missing something.

What I think I'll do is just make another field to import the phone nums into and split the numbers in FileMaker. I figured just splitting the numbers in excel before import would be easier, but I guess easy is no fun!

Thanks man

Ken

[Lee Smith]

Sorry, this isn't very clear.

What I said was I tried two different exports.

I exported the file as a .wks format. Then I just openned the file I had labled as .wks in Excel and it left the leading zeros.

I hope that is clearer and helpful

Lee:

[kenneth2k1]

I ended up just using another field and a script to parse the data after import to FM.

Thanks for you help anyways. I appreciate it.

ken