how to remove the apostrophe

[Guest]

Hi

i have a column that contains 8 digit code. However, the front starts with
'12345678. May i know how to remove the apostrophe ('). Kindly advise.

Thank you

 

[Lori]

Try selecting the column then choose Text-To-Columns on the data menu,
and click Finish.

 

[Phil]

Try selecting the column then choose Text-To-Columns on the data menu,
and click Finish.





- Show quoted text -

Or if you prefer to do it with a formula, you could use =VALUE(A1)

Regards

Phil

 

[Guest]

Do the following:

1. Select the column heading to select complete cells with the column.
Column cells that has text format appears aligned to the left.
2. On the Data menu, click Text to cloumns.
The Convert Text to Columns wizard is displayed.
3. Click Finish in the Step1 of 3 in the Convert Text to Columns wizard
dialog box.
All numbers aligns to right. This shows that the format for all the cells
are numbers.

Challa Prabhu