Number Format

  • Thread starter Thread starter JB
  • Start date Start date
J

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
 
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
 
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.
 
Nice! that worked too
Thanks

Shane Devenshire said:
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.
Click to expand...
 
Back
Top