Formula to Number

Closed
VG - Jul 22, 2010 at 03:57 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Jul 22, 2010 at 02:44 PM
Hello,

Can anyone help me, please? I have a 10 digit number that I need to divide into two and to place in two separate columns. I've used formulas (=LEFT(A1,5) and =RIGHT(A1,5)) to get the two five digit numbers.
However, these columns are now 'Formula' and I need them to be 'Numbers' so that my map software can read them (they are x,y coordinate values). Using the Formatting Cells function does not work. I'm not very profficient with Excel and really need some advice,

Any help would be much appreciated,
Thanks



1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Jul 22, 2010 at 02:44 PM
Select the columns
Copy
then choose pastespecial and paste as values
0