Spreadsheet Question

[Erika]

I received a spreadsheet from a customer and all of the information in the
spreadsheet has a ' in front of all the numbers entered. You can not see the
' until you attempt to edit the cell.

What did the customer do that those are showing up and how do I get rid of
them without editing each cell?

 

[Eduardo]

Hi Erika,
Maybe the information sent by the customes has been downloaded from other
program
to ride off that press
CTRL H
find what: enter '
replace with don't enter anything and click replace

sometimes there are spaces betwee the ' and the number so I usually edit the
number highlight the are from the beginning up to before the first number
click Ctrl C and then paste it into the find what area

if this helps please click yes, thanks

 

[Eduardo]

Hi Erika,
Maybe the information sent by the customes has been downloaded from other
program
to ride off that press
CTRL H
find what: enter '
replace with don't enter anything and click replace

sometimes there are spaces betwee the ' and the number so I usually edit the
number highlight the are from the beginning up to before the first number
click Ctrl C and then paste it into the find what area

if this helps please click yes, thanks

 

[Erika]

I did try Find and Replace and that did not work.

 

[Erika]

I did try Find and Replace and that did not work.

 

[Sean Timmons]

Please ensure you check your Find/Replace Options and that you do not have
Match Entire Cell Contents checked.

Assuming you can have the single quote deleted, you may also need to force
format the cells as number.

You can do this by typing 1 in a blank cell, copy, highlight your row of
numbers, paste special/Multiply.

 

[Sean Timmons]

Please ensure you check your Find/Replace Options and that you do not have
Match Entire Cell Contents checked.

Assuming you can have the single quote deleted, you may also need to force
format the cells as number.

You can do this by typing 1 in a blank cell, copy, highlight your row of
numbers, paste special/Multiply.

 

[Eduardo]

Hi,
Highlight the column, go to Data, Text to columns, delimited, check the box
that says semicolon, next next
Format your column as general

 

[Eduardo]

Hi,
Highlight the column, go to Data, Text to columns, delimited, check the box
that says semicolon, next next
Format your column as general