Formatting Data

  • Thread starter Thread starter Gazz_85
  • Start date Start date
G

Gazz_85

I can export from my MRP system into an excel format, but this does it in a
way so that i can't manipulate the data. all the cells have a ' before the
value. I've tried deleting the ' but it still doesn't let me
reformat......any ideas???
 
Hi,
Highlight all the data, CTRL + H, find what enter ', then click replace

another option

in another column enter

=trim(A1)

then copy this column as value
 
Enter a 1 in some empty cell. Do Edit - Copy on that cell. Select all the
cells you want to change. Do Edit - Paste Special - Multiply. Done. HTH
Otto
 
It didn't work???

Eduardo said:
Hi,
Highlight all the data, CTRL + H, find what enter ', then click replace

another option

in another column enter

=trim(A1)

then copy this column as value
Click to expand...
 
Back
Top