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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete Timestamp 2
Figures locked in text format 5
Best third-party tool to repair OST files 2
Changing the cell format doesn't change existing cell content 2
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
retain custom date format "text" when pasting or reformatting data 2
Date Formating Problem 1
Excel reading pasted values as Scientific Notation 3

Back
Top