Excel query
Dan Coutu
coutu at snowy-owl.com
Fri Feb 25 13:26:00 PST 2005
On Fri, 2005-02-25 at 12:17 -0800, Anthony Terrible wrote:
> You might try bringing it into Excel as text. We have done this by
> running a report separating fields by commas then putting ' in front
> of the field on the report. When it imports into Excel it's treated as
> text so it appears exactly as written.
This is one possible solution and is probably the simplest. Excel does
also provide a 'custom' format rule that can be applied to the column
that will prevent the number from being displayed using scientific
notation. Select the whole column and then modify the format of it to be
what they call the custom numeric format.
--
Dan Coutu
Managing Director
Snowy Owl Internet Consulting, LLC
http://www.snowy-owl.com/
More information about the Filepro-list
mailing list