drops

Hi all I'd like to build a scatter graph with a slight difference. In the source data there are 2 variables for each person, and both can shift in either direction (up or down). Normally we plot a single point for each person on a scatter and just have different scatters for different data...

How do I get the right function to pick up 0 as the second decimal place? I'm trying to get zero from =RIGHT(A1) where A1 is 2,366,125.60 but excel is picking up the 6 since it drops the last zero. Thanks

Value = $7,564,264.00 I need this to become a sixteen character text string: 0000000756426400 my formula =Text(Text(substitute(B13,".",""),"0000000000000000" becomes 000000007564264 this works if, for example, the number is $5,469,062.72, but for any round number, it drops the decimal...

Hello - I have a horizontal line chart that contains numerous high and low points (with time and date stamps). I am trying to write a formula (or find a function) that would calculate the distances between each high and low point for each of the drops (sometimes numerous ups and downs per...

Hi All, I have a data string in column A that i need to split out by the "_", however when i use text to columns it drops the leading zero's. Can anyone help in coming up with a solution? Example of the string is below <tbody> 211_0807_1009_00_03 </tbody>