converting Number

T

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
 
M

MDubbelboer

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

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

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
 
S

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
 
Top