![]() |
|
#1
|
|||
|
|||
![]() I have data that I downloaded from an online site. The numbers are coming in as General so I can't add them unless I retype each number over again. Is there a better solutions to this issue. |
#2
|
||||
|
||||
![]()
Arithmetic operations will coerce text to numbers automatically, but if you want to change all in one go, select all cells - Data Text To Columns - Finish
You should now have real numbers to play with
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
![]()
Pecoflyer,
I did find a formula that works also, =LEFT(A1,LEN(A2)*1)*1 I like your method better, it's quicker. Thanks for your help!!! |
#4
|
||||
|
||||
![]()
Thanks. Depending on what is needed there are a number of solutions to this kind of problem
BTW in the expression LEN(A2)*1 the multiplication is not necessary
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to change number format of dates | ketanco | Project | 1 | 09-11-2012 02:34 PM |
Footnotes: custome number format | btorrance | Word | 2 | 07-30-2012 10:47 AM |
![]() |
officeclerk | Excel Programming | 2 | 04-17-2012 01:23 AM |
![]() |
Ward | Excel | 1 | 06-07-2011 08:18 PM |
![]() |
boutells | Excel | 1 | 05-20-2009 02:46 PM |