How do I convert from:

1937.2
968.6
24215
701.4
1202.4


to

-1937.20
-968.60
-24215.00
-701.40
-1202.40


--
TaGY2K
------------------------------------------------------------------------
TaGY2K's Profile: http://www.excelforum.com/member.php...fo&userid=1861
View this thread: http://www.excelforum.com/showthread...hreadid=563499

put -1 in a cell
copy the cell
highlight the range you want converted and right click, paste
special->multiply


--
MDubbelboer
------------------------------------------------------------------------
MDubbelboer's Profile: http://www.excelforum.com/member.php...o&userid=36330
View this thread: http://www.excelforum.com/showthread...hreadid=563499

Enter -1 in an unused cell then copy that cell. Select the range that you
want to convert then select Paste Special > Multiply

--
HTH

Sandy
In Perth, the ancient capital of Scotland

(E-Mail Removed)
(E-Mail Removed) with @tiscali.co.uk


"TaGY2K" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
>
> How do I convert from:
>
> 1937.2
> 968.6
> 24215
> 701.4
> 1202.4
>
>
> to
>
> -1937.20
> -968.60
> -24215.00
> -701.40
> -1202.40
>
>
> --
> TaGY2K
> ------------------------------------------------------------------------
> TaGY2K's Profile:
> http://www.excelforum.com/member.php...fo&userid=1861
> View this thread: http://www.excelforum.com/showthread...hreadid=563499
>

May not be the best way, but why not change the NumberFormat to "0.00"
then multiply the cells by -1.

Or if you're not using VBA, set a cell as -1 and then paste special that
to all the cells as a multiply. Then go and change the number format
for those cells.

Probably the most direct way.

TaGY2K wrote:
> How do I convert from:
>
> 1937.2
> 968.6
> 24215
> 701.4
> 1202.4
>
>
> to
>
> -1937.20
> -968.60
> -24215.00
> -701.40
> -1202.40
>
>

cool.. thanks for your help


--
TaGY2K
------------------------------------------------------------------------
TaGY2K's Profile: http://www.excelforum.com/member.php...fo&userid=1861
View this thread: http://www.excelforum.com/showthread...hreadid=563499

ok.. both way wrks.. thanks for the help guys!


--
TaGY2K
------------------------------------------------------------------------
TaGY2K's Profile: http://www.excelforum.com/member.php...fo&userid=1861
View this thread: http://www.excelforum.com/showthread...hreadid=563499

How about if I want to add 000 in front of the number? ie:

1937.2
968.6
24215
701.4
1202.4

to

0001937.2
000968.6
00024215
000701.4
0001202.4


--
TaGY2K
------------------------------------------------------------------------
TaGY2K's Profile: http://www.excelforum.com/member.php...fo&userid=1861
View this thread: http://www.excelforum.com/showthread...hreadid=563499

If you want three 0's regardless of the number of digits then use the Custom
format:

"000"#.##

if you want a constant number of digits before the decimal point then use:

0000000.#

--
HTH

Sandy
In Perth, the ancient capital of Scotland

(E-Mail Removed)
(E-Mail Removed) with @tiscali.co.uk


"TaGY2K" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
>
> How about if I want to add 000 in front of the number? ie:
>
> 1937.2
> 968.6
> 24215
> 701.4
> 1202.4
>
> to
>
> 0001937.2
> 000968.6
> 00024215
> 000701.4
> 0001202.4
>
>
> --
> TaGY2K
> ------------------------------------------------------------------------
> TaGY2K's Profile:
> http://www.excelforum.com/member.php...fo&userid=1861
> View this thread: http://www.excelforum.com/showthread...hreadid=563499
>