converting Number

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TaGY2K - 20 Jul 2006 22:44 GMT

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

Signature

TaGY2K

Reply to this Message

MDubbelboer - 20 Jul 2006 22:46 GMT

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

Signature

MDubbelboer

Reply to this Message

TaGY2K - 20 Jul 2006 22:55 GMT

cool.. thanks for your help :)

Signature

TaGY2K

Reply to this Message

TaGY2K - 20 Jul 2006 22:57 GMT

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

Signature

TaGY2K

Reply to this Message

Sandy Mann - 20 Jul 2006 22:53 GMT

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

Signature

HTH

Sandy
In Perth, the ancient capital of Scotland

sandymann2@mailinator.com
Replace@mailinator.com with @tiscali.co.uk

> How do I convert from:
>
[quoted text clipped - 11 lines]
> -701.40
> -1202.40

Reply to this Message

TaGY2K - 20 Jul 2006 23:08 GMT

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

Signature

TaGY2K

Reply to this Message

Sandy Mann - 20 Jul 2006 23:43 GMT

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

Signature

HTH

Sandy
In Perth, the ancient capital of Scotland

sandymann2@mailinator.com
Replace@mailinator.com with @tiscali.co.uk

> How about if I want to add 000 in front of the number? ie:
>
[quoted text clipped - 11 lines]
> 000701.4
> 0001202.4

Reply to this Message

John Forrest - 20 Jul 2006 22:53 GMT

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.

> How do I convert from:
>
[quoted text clipped - 11 lines]
> -701.40
> -1202.40

Reply to this Message