Special character apostrophe ' in Excel (ASCII code = 39)

Character apostrophe ('), or single quotation mark, has special function in MS Excel.

 It is used to indicate that the following character is stored as text.
 And it's NOT display when it's used in that function.

 Example:

 The original number: 0123456
By default, MS Excel will omit the 0 digits at start of number
If you want to keep digits 0, you can put apostrophe (') at the beginning of the number (no need to change format to text).
add ' to keep digit 0

So far, we have known the function of single quotation mark, but it's may be annoying sometime. As it is not visible, you may miss the value of the cell, which contain ' at the beginning.
We can't display character ' at the beginning of cell value



 For normal user, this would be OK. But for me, work with data that start with ', it's really annoying.
Anyone who has the same problem with me, I hope you can find the solution and share with me :)

Have a nice day!



Nhận xét

Đăng nhận xét

Bài đăng phổ biến từ blog này

[sapui5] Best Practice in sapui5 development

Hình ảnh
Hi, Small Tips but no many knows: - Use this.getResouceBundle().getText(sKey, aParam) - Use BaseController (instead of creating a Util service). - Odata Model resetChanges() & submitChanges() ('TwoWay' binding required). Allow TAB to navigate within a table: Use property " keyboardMode " of ListBase . Set it to value " sap.m.ListKeyboardMode.Edit " and it would allow users to use TAB to move to the next cell in a table (the same behavior in MS Office table). API: https://sapui5.hana.ondemand.com/sdk/#/api/sap.m.ListBase/controlProperties https://sapui5.hana.ondemand.com/sdk/#/api/sap.m.ListKeyboardMode/overview References Advanced JS technique to shorten your code: Below hand-on with explanation will help you to shorten your frontend code a lot. Make the code more succinct, readable & easier to maintain. Functional Programming for your UI5 Apps Hands-On Worksheet Keep in mind the mindset: Think "everythin...
Đọc thêm

Implement Search field with case-INSENSITIVE by SAP UI5

Hello guys, Continue to read if you're sapui5 developer, or you work closely with UI development. At the time I write this post, SAP UI5 and Odata does not support filter with case sensitivity. Odata provide some filter parameter that help you to filter with case-INSENSITIVe. However, you hardly modify the URI of ODATA service in your font end SAP UI5 code. Most of us use API provided from SAP , we only provide the parameter to API function, then let the API from SAPUI5 library handle the ODATA service URL. In short, I mean we cannot, or hardly, modifying the odata GET request as we want, but use the standard API instead. Return to the main topic, we need to write a function to filter the ODATA get request so that we get the returned data filtered as the way we want (filter with case-INSENSITIVE). For example: you type " test " in the search field, then you should get the results with all the entries containing "test", or "Test", or "TES...
Đọc thêm

[sapui5][abap] Use Eclipse to push code to ABAP repository (temporary)

Hình ảnh
Hi, For now, local SAP Web IDE cannot be used to push code to ABAP repository. So we have to use Eclipse as a workaround. This post we will make a tutorial to do that. 1. Setup Eclipse environment: - Get Eclipse as described in this link . - If your company use firewall, you may have an error connecting to the Internet when "Install new software...". In that case, please use network proxy to access the internet ( should ask your IT department the proxy server information ): You can check whether the software gets installed or not by checking in Help/About : 2. Connect to ABAP repository using SAP GUI: Make sure that the connection is ready & on so that you can connect easily using Eclipse. - Open SAP GUI. - Check if your connection is working, if not; create a new connection to your server: Create new connection Input server information to connect to NOTE: in case your eclipse still cannot see the connection (eg. C46), you need to m...
Đọc thêm