converting Number

[TaGY2K]

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

[MDubbelboer]

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

[John Forrest]

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
>
>

[TaGY2K]

cool.. thanks for your help

[TaGY2K]

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

[Sandy Mann]

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

[email protected]
[email protected] with @tiscali.co.uk


"TaGY2K" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[TaGY2K]

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

[Sandy Mann]

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

[email protected]
[email protected] with @tiscali.co.uk


"TaGY2K" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>