Formula to Number

Closed

VG - Jul 22, 2010 at 03:57 AM
rizvisa1 Posts 4478 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

Formula to Number
Number to words in excel formula - Guide
Logitech formula vibration feedback wheel driver - Download - Drivers
Date formula in excel dd/mm/yyyy - Guide
Excel grade formula - Guide
Credit summation formula - Guide

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jul 22, 2010 at 02:44 PM

Select the columns
Copy
then choose pastespecial and paste as values

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel

How to calculate position (1st,2nd,3rd) in excel....?

Calculation of positions in excel

formulas for 1st and 2nd position in class

Similar discussions

Subscribe To Our Newsletter!