Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
text to numeric
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
text to numeric
See
http://www.mcgimpsey.com/excel/postfixnegatives.html In article , CLEM wrote: I have imported data into Excel 97 and negative numbers appear in columns like this: 123.45- 24.21- 1000.78- These are text and will not allow any sums. How can I convert the above to numeric values so they appear as follows: -123.45 -24.21 -1000.78 OR (123.45) (24.21) (1000.78) Thanks, |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
text to numeric
On Oct 16, 2:51 pm, JE McGimpsey wrote:
See http://www.mcgimpsey.com/excel/postfixnegatives.html In article , CLEM wrote: I have imported data into Excel 97 and negative numbers appear in columns like this: 123.45- 24.21- 1000.78- These are text and will not allow any sums. How can I convert the above to numeric values so they appear as follows: -123.45 -24.21 -1000.78 OR (123.45) (24.21) (1000.78) Thanks, Try following in the colomn next to imported =IF(RIGHT(A2,1)="-",VALUE(LEFT(A2,LEN(A2)-1)),VALUE(LEFT(A2,LEN(A2)))) Cheers Harold |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
text to numeric
Thank you both, this solved my problem!!!!!!!!!!!!!!!!!
"mohavv" wrote: On Oct 16, 2:51 pm, JE McGimpsey wrote: See http://www.mcgimpsey.com/excel/postfixnegatives.html In article , CLEM wrote: I have imported data into Excel 97 and negative numbers appear in columns like this: 123.45- 24.21- 1000.78- These are text and will not allow any sums. How can I convert the above to numeric values so they appear as follows: -123.45 -24.21 -1000.78 OR (123.45) (24.21) (1000.78) Thanks, Try following in the colomn next to imported =IF(RIGHT(A2,1)="-",VALUE(LEFT(A2,LEN(A2)-1)),VALUE(LEFT(A2,LEN(A2)))) Cheers Harold |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation numeric and text | Excel Discussion (Misc queries) | |||
Text treated as a numeric value? | Excel Discussion (Misc queries) | |||
Numeric in Text to convert back to the form of Numeric for VLookup Purposes | Excel Discussion (Misc queries) | |||
Text to Numeric | Excel Worksheet Functions | |||
Text to Numeric format | Excel Discussion (Misc queries) |