How do I import data and display zeros?
I am exporting information out of FileMaker Pro 7 and importing this Data
into Excel 2003. How do I or can I display the zeros that are at the beginning of the number? Thank you. |
If can convert it to a txt file you can use the text import wizard and
select text as column data format in step 3 -- Regards, Peo Sjoblom "caram" wrote in message ... I am exporting information out of FileMaker Pro 7 and importing this Data into Excel 2003. How do I or can I display the zeros that are at the beginning of the number? Thank you. |
caram
You can try pre-formatting the cells in Excel as Text prior to the import. You could also export the FM Pro output to a text file then open that in Excel. The Text Import Wizard will allow you to leave the zeros. Or import to Excel and Custom Format to 000000 or somesuch. Gord Dibben Excel MVP On Tue, 26 Apr 2005 12:19:01 -0700, "caram" wrote: I am exporting information out of FileMaker Pro 7 and importing this Data into Excel 2003. How do I or can I display the zeros that are at the beginning of the number? Thank you. |
All times are GMT +1. The time now is 09:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com