I have users that import data into a large spreadsheet . The data is setup
without any decimal places. I also have a blank rows in between the data so
if I multiply the column by .01 the empty cells now have a zero (0). These
cells need to stay blank. Does anyone have any suggestions on how to
accomplish this task in one formula or code.

Example Cells G1 = 12345 and G2 = Blank and G3 = Blank and G4 = 45678

I would like data to be G1 = 123.45 G2 = Blank G3 = Blank and G4 = 456.78

Thanks for your help.

Gladys