formatted

I type this: 12345678987654321 And I get this: 12345678987654300? Formatted as number. Thanks, -Jim

Hi I was looking for help to create some data block code. Whats really important is the ability to add more data blocks (anywhere on my sheet) over time and that's why I have chosen data blocks (hope I’m correct). I have found some code and could include it in the post if that will save...

SUMIFS has given me a headache, since I can't get the formula below to work, though I'm probably just too close to the trees to see the issue. :eeek: SUMIF works fine on TT and AH alone, but when both are used with SUMIFS, only zeros are returned. What am I missing? Any help will be highly...

I have a spreadsheet with peoples hours worked, formatted as [h]:mm:ss Their rate of pay, formatted as 0.0 In order to multiply them together, with the result formatted as 0.0, I an getting random results, does anyone know where I am going wrong ? Thanks Paul

Hello all, I'm completely stumped with something on excel. I'd like to think of myself as a decently proficient user but I just cant get to the bottom of this. I've started a new job in a call centre and we have data that is annoyingly formatted. We have multiple customers and it is formatted a...

Hi all, I am using this formula to return a number that's left of the "x". This formula would return a 2 but formatted as text. How can I get the same result formatted as a number? =IFERROR(LEFT(N41,SEARCH("x",N41)-1),"") Thank you! Russ

I am having trouble with the X Axis being formatted differently in two different charts using the same source data. In the first chart, the X Axis presents exactly as it is formatted in the source data: 2010, 2011, 2012, etc. In the second chart, the X Axis, while referencing the same...

I have medium knowledge of excel however I have a form, which is formatted to only accept numbers, that upon completion adds that data to certain cells in a worksheet, of which cells are also formatted as numbers. However, somewhere in my data it must change it back to a text as the autosums...

Hi all, I have an excel sheet that performs some automatic tasks, one of them is creating a string that contains a HTML formatted text that contains the body of an email and then sending it via email. I'd like to have the possibility of showing the formatted result of the email body generated...

I am using the formula =SUMIF(B2:NB2,">"&NC3,B4:NB4), row 2 is all consecutive dates, NC3 is today's date minus 1 year, and row 4 is accrued points that populate from a different page. I can't get anything to return except an error and I can't figure out why. Text, dates and numbers are...

Hi, I have a "floating point" issue on a spreadsheet I receive and need to convert the time that is a decimal (formatted as "08:00", 08:15", "08:30", etc etc) to 0800 or 800 etc.. Anyone have a formula for this? thanks J

Hello there, I am a newbie VBA user here. By default, the 'Currency' cells of the entire workbook are formatted in 2 version (difference is just in decimal point, as per below): .NumberFormat = "$#,##0.00" .NumberFormat = "$#,##0"What I am trying to do is, when the case of 1 cell on the main...

I want to have data from one worksheet copied and moved to another worksheet. I want to have a button to do this action. Can someone give me guidance on where I should start? I want to have one sheet where I have data formatted and colored according to different conditions I set. I want to...

hello, I'm using the "&A1&" formula to reference dollar value totals. Cell A1 is formatted to 2 decimal points, but the referenced cell destination is adding more than 2 decimal places! thanks

Hello All, i am having issues with creating CF for a specific column. column is for delivery ETAs. so most of the cells have a date in it, so the column is formatted to dates. however for some of the cells we are waiting for the ETA so have "pending" written in it. i can't seem to be able...

My UserFormDataEntry uses 3 TextBoxes to add the phone number to the cell as ########## My worksheet displays the formatted phone numbers as (###) ###-#### How do I extract the numbers from the worksheet cell into another UserForm with 3 Textboxes? This doesn’t work: Me.TextBox4.Value =...

Good day I am using Excel out of Office 365 on Windows10. I have a worksheet that tracks motorcycle rides. The setup is as follows: Column A - date of a ride. formatted as date. Column B - ride number. formatted as number with no decimal points. can go as high as three digits. Column C -...

I have the following formula im having a little trouble with. =(C12&" "&D12&"x "&E12&" "&F12) C12 is formatted as Fractional and D12 is formatted as Short Date. They are showing up as numbers in a decimal. Is there a way to have the format called out for each cell in the formula.

Hi, I am seeking a solution for the following topic: - two cells have data validation set up as a list being {1,2,3,4,5} - the first call has general number format while the second ons is formatted as a custom number format being: "0;;-" - data entry in these cells is now possible either via...

Hi all, our part numbers are entered onto Excel, and the cells are formatted as "text" in order to keep the part numbers in their original format. Which is great, until we run a macro and the parts lose their formatting and return to Examples 000456 becomes 456 1.10000 becomes 1.1 I sort of...