View Single Post
  #1   Report Post  
REReed REReed is offline
Junior Member
 
Posts: 3
Default Format a Range to Multiply by 1000

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