Jump to content

Excell Numeric Formatting


coopersred
 Share

This topic is 5596 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

I need to import an Excel spreadsheet into Filemaker to convert it to a database. I have one column that displays UPC codes as 14 digit numbers in my spreadsheet. In Excel I can format the cells so that it always show 14 digits. For example if I enter 22211704423, Excel will add three leading zeros and format the cell as: 00022211704423

Is there any way I can do this in Filemaker?

Thanks

Link to comment
Share on other sites

Hi coopersred

yes, you can do it in FileMaker.

Make a text field (UPCcodes) with AutoEnter/Replace option based on this calculation:

Right( "00000000000000" & UPCcodes ; 14 )

Whatever number you'll insert into the field, FM will convert it to a text field of 14 chars with the correct number of leading zeros.

Link to comment
Share on other sites

I'm trying to duplicate the problem for my own knowledge.

Although the formula that Daniele provided will take care your need, I'm curious as to why FileMaker would be dropping these leading zeros, if they are actually there in the export. I did a test of export from Excel using a Text field with the zeros, and it imported (opened) with the leading zeros intact.

TIA for your feedback.

Lee

Edited by Guest
Link to comment
Share on other sites

This topic is 5596 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.