Another way is to use Paste Special...
Enter the numbers without the 3 trailing zeros.
Enter 1000 in a separate cell, away from the data, and copy it.
Select your data and then choose Paste Special from the Edit menu and then select Multiply.
--
Jim Cone
Portland, Oregon USA .
http://www.mediafire.com/PrimitiveSoftware .
(Formats & Styles xl add-in: lists/removes unused styles & number formats) - free
"REReed" <rer-SPAMTRAP-(E-Mail Removed)>
wrote in message
news:(E-Mail Removed)...
>
> I am trying to make a worksheet where any numerical value I type is
> automatically multiplied by 1000.
>
> I am working with lots of numbers but I do not want to type all the
> zeros.
> For example, I want to be able to type 749.1 and have 749100 appear in
> the
> cell. I know how to do this for just one cell but I cannot figure out
> how to do
> this for a range of cells. Specifically, I want this to be applied to
> all the cells in
> columns F-H.
>
> Any suggestions?
> Thanks
>
>
>
>
> --
> REReed
Similar Threads
