MARCEDIT-L Archives

November 2012

MARCEDIT-L@LISTSERV.GMU.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Kristina Spurgin <[log in to unmask]>
Reply To:
Date:
Fri, 16 Nov 2012 17:06:09 -0500
Content-Type:
text/plain
Parts/Attachments:
text/plain (55 lines)
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]

ATOM RSS1 RSS2