Excel number formatting

  • Thread starter Thread starter lintcoop
  • Start date Start date
L

lintcoop

I am importing large data sets from several different sources. The
numeric data has a decimal as required. In other words:
100.00 = 100
100.10 = 100.1
100.11 = 100.11

I need to eliminate all decimals but not affect the amount with
rounding.
Ultimately I need the format to be 10000, 10010 and 10011 for the 3
example amounts.

I'd appreciate any suggestions.
Thanks
 
I am importing large data sets from several different sources. The
numeric data has a decimal as required. In other words:
100.00 = 100
100.10 = 100.1
100.11 = 100.11

I need to eliminate all decimals but not affect the amount with
rounding.
Ultimately I need the format to be 10000, 10010 and 10011 for the 3
example amounts.

I'd appreciate any suggestions.
Thanks
Click to expand...

After you import, multiply the values by 100.


--ron
 
I may be a bit fuzzy in my old age, but, why not just multiply the values by
100?

--
Regards;
Rob

Please reply to the NG.
I'm already up to my eyeballs in
Nigerian/South African get rich
letters as well as "Microsoft Critical Updates" et al.
 
Back
Top