Formatting Data
 

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???

Formatting Data
 

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


"Gazz_85" wrote:

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???

Formatting Data
 

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
"Gazz_85" wrote in message
...
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???

Formatting Data
 

It didn't work???

"Eduardo" wrote:

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


"Gazz_85" wrote:

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???