Try setting format to "Number" with 0 decimal places.
best,
-=-
Kristina M. Spurgin
E-RESOURCES CATALOGER
E-Resources & Serials Management, Davis Library
University of North Carolina at Chapel Hill
CB#3938, Davis Library -- Chapel Hill, NC 27514-8890
919-962-2050 -- [log in to unmask]
On 11/16/2012 3:24 PM, Hults, Patricia wrote:
> I just tried this and still have the wrong format when I pull it into MarcEdit. Good suggestions, though. - Pat
>
> Patricia Hults
> Manager of Technical Services
> Rensselaer Libraries
> Rensselaer Polytechnic Institute
> 110 8th St.
> Troy, NY 12180-3590
> (518) 276-8358
> [log in to unmask]<mailto:[log in to unmask]>
>
>
> From: MarcEdit support in technical and instructional matters [mailto:[log in to unmask]] On Behalf Of Mark K. Ehlert
> Sent: Friday, November 16, 2012 3:15 PM
> To: [log in to unmask]
> Subject: Re: Problem with numbers in delimited text translator
>
> Hults, Patricia <[log in to unmask]<mailto:[log in to unmask]>> wrote:
> The problem is Excel displays the data in the "text" format the same way it does in the "general" format - 9.7638E+12 instead of 9783800734528. And that's how MarcEdit also displays it.
>
>
> Try "Custom" and the 00000 format.
>
> --
> Mark K. Ehlert Minitex
> Coordinator University of Minnesota
> Digitization, Cataloging & 15 Andersen Library
> Metadata Education (DCME) 222 21st Avenue South
> Phone: 612-624-0805 Minneapolis, MN 55455-0439
> <http://www.minitex.umn.edu/>
> ________________________________________________________________________
>
> This message comes to you via MARCEDIT-L, a Listserv(R) list for technical and instructional support in MarcEdit. If you wish to communicate directly with the list owners, write to [log in to unmask]<mailto:[log in to unmask]>. To unsubscribe, send a message "SIGNOFF MARCEDIT-L" to [log in to unmask]<mailto:[log in to unmask]>.
>
> ________________________________________________________________________
>
> This message comes to you via MARCEDIT-L, a Listserv(R) list for technical and instructional support in MarcEdit. If you wish to communicate directly with the list owners, write to [log in to unmask] To unsubscribe, send a message "SIGNOFF MARCEDIT-L" to [log in to unmask]
>
________________________________________________________________________
This message comes to you via MARCEDIT-L, a Listserv(R) list for technical and instructional support in MarcEdit. If you wish to communicate directly with the list owners, write to [log in to unmask] To unsubscribe, send a message "SIGNOFF MARCEDIT-L" to [log in to unmask]
|