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?
Thanks!
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?
Thanks!
"TimmerSuds" <[email protected]> wrote
in message news:[email protected]...
>
> 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?
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.
--
David Biddulph
"TimmerSuds" <[email protected]> wrote
in message news:[email protected]...
>
> 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?
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.
--
David Biddulph
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks