Posted to microsoft.public.excel.programming

edwardpestian[_25_] edwardpestian[_25_] is offline

external usenet poster

Posts: 1

AS400 copy problem

I have a range of cells A1:A10 in which data is pasted from AS400. Th
data is pasted in a 2340- format for a negative number. What I'
looking for is when the data is pasted into these cells, for excel t
automatically change the format from 2340- to <2340.

Thanks.

e

--
edwardpestia
-----------------------------------------------------------------------
edwardpestian's Profile: http://www.excelforum.com/member.php...fo&userid=3380
View this thread: http://www.excelforum.com/showthread.php?threadid=55636

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
AS400 transfer via VBA	[email protected][_2_]	Excel Programming	1	February 24th 06 07:11 PM
Automatic transfer AS400- Excel	Warzel	Excel Programming	1	January 17th 05 04:55 PM
Excel and AS400 DB2 database	Esperanza[_2_]	Excel Programming	0	December 28th 04 09:06 PM
DDE to Query AS400 DB	Joseph[_26_]	Excel Programming	0	February 9th 04 10:46 PM
SQL against AS400	R. Choate	Excel Programming	4	November 7th 03 09:11 PM

All times are GMT +1. The time now is 06:48 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us