Number Format

[JB]

Hello
I've got a large spreadsheet which was imported. Apart from the first 2
columns, the rows consist of number which I need to filter, but this isn't
working. Then I noticed an apostrophe before each number in every cell,
which doesn't show in the cell but up in the formula/text bar.
I've set all the columns to numbers but the apostrophe won't go away.
Please can someone tell me how I can without having to go into each cell as
there are hundreds.
Thank you
J

 

[Rick Rothstein]

Select all the columns with these "numbers" in them, then right click the
tab at the bottom of the worksheet and select View Code from the popup menu
that appears, then copy/paste this statement into the Immediate Window (if
you don't see the Immediate Window, press Ctrl+G) and, with the text cursor
somewhere on the statement, hit the Enter key...

Selection.Formula = Selection.Formula

 

[Shane Devenshire]

Hi,

Click a blank cell and copy it
Select all the cells that should be numbers and choose Edit, Paste Special,
Add.

Done.

If this helps, please click the Yes button.

 

[JB]

Coooooooooool. that was fun and worked a treat
Ta

 

[JB]

Nice! that worked too
Thanks

Hi,

Click a blank cell and copy it
Select all the cells that should be numbers and choose Edit, Paste
Special,
Add.

Done.

If this helps, please click the Yes button.