Text Format

[Syed Haider Ali]

I have Column A with format General. I convert this Col with format as Text from cell format. However this col is not treating as Text until again editing every entry. Any Suggestion Please.


Syed Haider Ali

[AliGW]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[Syed Haider Ali]

I used Sumif formula in Cell D5 to get result from Trail sheet based on B5. The Col A of Trial Sheet in a General Format. I Converted this Col into Text Format. However without editing every entry in Col A again I cannot get the result in Cell D5 of Result sheet. For example I edited Cell A4 of trial thus resulting balance of Code 11000001 in D5 of Result sheet. If I edit cells from A4 to A10, I will get result in D4 350,000,000. Is there a way to get this result without editing Cell A4 to A10 in Trial Sheet

[Glenn Kennedy]

Try this array formula. However, it might e more helpful if you posted your ORIGINAL data, with your original formatting.

=SUM(IF((LEFT(Trial!$A$4:$A$24,4)=TEXT(B5,0)),Trial!J4:J24))

Array Formulae are a little different from ordinary formulas in that they MUST be confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER.

You will know the array is active when you see curly braces { } appear around the outside of your formula. If you do not CTRL+SHIFT+ENTER you will (almost always) get an error message or an incorrect answer. Press F2 on that cell and try again.

Don't type the curly braces yourself - it won't work...