Changing Negative Sign from Back to Front

's Computer Specifications

I have a large set of data, most of it being numerical. In one column
however, the data imported was imported with negative values having
the negative placed at the end of the number. (ie 2314-, 543-) as
opposed to (-2314 or -543). Does anyone have a quickfix for this
problem?

's Computer Specifications

Backup your database. Do update like this --
"-" & Left([YourField],InStr([YourField],"-")-1)
--
KARL DEWEY
Build a little - Test a little

"(E-Mail Removed)" wrote:

> I have a large set of data, most of it being numerical. In one column
> however, the data imported was imported with negative values having
> the negative placed at the end of the number. (ie 2314-, 543-) as
> opposed to (-2314 or -543). Does anyone have a quickfix for this
> problem?
>
>

's Computer Specifications

How about:

IIf(InStr([Field1],"-")>0,-1*Abs(Val([Field1])),[field1])

On May 22, 11:39 am, dipin.p...@gmail.com wrote:
> I have a large set of data, most of it being numerical. In one column
> however, the data imported was imported with negative values having
> the negative placed at the end of the number. (ie 2314-, 543-) as
> opposed to (-2314 or -543). Does anyone have a quickfix for this
> problem?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Switching negative signs from back to front	tracytracy123	Microsoft Excel Misc	4	23rd Jun 2009 04:34 PM
Changing the Negative Sign	=?Utf-8?B?dGVkZDEz?=	Microsoft Excel Programming	5	1st May 2006 05:05 PM
Reversing Sign on Column of Data (Positive to Negative) (Negative to Postive)	M Stokes	Microsoft Excel Worksheet Functions	1	26th Apr 2004 04:33 PM
Moving minus sign from back to front of number	Paula	Microsoft Excel Misc	3	11th Mar 2004 12:53 AM
Re: Importing negative numbers when negative sign is at the back of the number	Ken Snell	Microsoft Access External Data	3	5th Aug 2003 07:14 AM