Custom Number Format

T

TimmerSuds

I have a column with numbers like:

33.35
21.01
42.7
12.01
21

I need to convert them all to:

3335
2101
4270
1201
2100

What would be the easiest way to accomplish this? Can it be done with
custom number format?

Thanks
 
D

David Biddulph

TimmerSuds said:
I have a column with numbers like:

33.35
21.01
42.7
12.01
21

I need to convert them all to:

3335
2101
4270
1201
2100

What would be the easiest way to accomplish this? Can it be done with a
custom number format?
Click to expand...

If you want to change the number, rather than merely display in a different
format, the easiest way is to type 100 into a spare cell, copy that, select
the cells you want to change, then Edit/ Paste Special/ Multiply.
 
Top