Import from extern data sheet

  • Thread starter Thread starter Himselff
  • Start date Start date
H

Himselff

Hi guys,

Im importing data into my workbook from another excel sheet and in a colomn that data is in format xx.xx% so whit my regional parameter set to decimal on "," i replace everything,

at this point all seem ok but the data seem in stand by for something , the only way to make my data seen in formula or in graphic is to edit(f2) and press enter each cell, and after that all goes good !

Ne1 got an idea how to fix that ?

Thanks a lot in advance !

Him


--
*************************************
Frederick Lamontagne
Network Administrator
email:[email protected]
*************************************
http:\\www.concepptechnologies.com
http:\\www.icform.us
http:\\www.polyform.com
 
Im importing data into my workbook from another excel sheet
and in a colomn that data is in format xx.xx% so whit my
regional parameter set to decimal on "," i replace everything,
Click to expand...
at this point all seem ok but the data seem in stand by for
something , the only way to make my data seen in formula
or in graphic is to edit(f2) and press enter each cell, and
after that all goes good !
Click to expand...
Ne1 got an idea how to fix that ?
Click to expand...

Enter 1 in an empty cell. Copy it. Paste/Special over the top of
the data and select Multiply. You may have to reformat.
 
Back
Top