G
Guest
without doing anything complicated I can think of a couple
of ways:
type the numbers first, then copy 100 to the clip board,
select all the data and use Pase Special/ divide
Or use a column next to it with the formula = A1/100
you will also have to set the number cell fomat to 0.00 as
in the other reply posted.
hope that helps
of ways:
type the numbers first, then copy 100 to the clip board,
select all the data and use Pase Special/ divide
Or use a column next to it with the formula = A1/100
you will also have to set the number cell fomat to 0.00 as
in the other reply posted.
hope that helps