MS Excel: Convert a text to a numberhttps://www.joellipman.com/articles/microsoft/excel/ms-excel-convert-a-text-to-a-number.html

15 November 2013 peso by the conversion rate, it returns #VALUE! How? The problem is that I have a column which includes the currency symbol as per the following image: I create another column with the symbol omitted using the formula: =SUBSTITUTE(B3, "₱", "") Which...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: en-GB

Windows OS: Alt Codes / Symbols / Special Charactershttps://www.joellipman.com/articles/microsoft/windows-os/windows-os-alt-codes-symbols-special-characters.html

03 June 2021 character is built of a collection of digits that are to be entered in their specific order. Search for "Alt Codes" or "Symbol Codes" in a search engine for a full list. Meanwhile, here's some that you may need frequently: Currency ¢ Cent sign 0162 £...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

04 October 2013 // PRIMARY transformation: Applies to all words // (lowercases and capitalizes first letter taking into account punctuation symbols) ValueToConvert = textInfo.ToTitleCase(ValueToConvert.ToLower()); // add a trailing space to catch below exceptions (eg....

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• Language: en-GB

Zoho Creator: Render to PDF with margins and page numbershttps://www.joellipman.com/articles/crm/zoho/zoho-creator-render-to-pdf-with-margins-and-page-numbers.html

07 May 2024 could be the same under price total. Where a price is applied, values should be retained in decimal format with currency symbol prefixed if value is greater than zero. Source(s): To convert Page to PDF - Used more for links to open the PDF renderer in a...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM / Client Script / Canvas: Hide Tab based on Pipelinehttps://www.joellipman.com/articles/crm/zoho/zohocrm-client-script-canvas-hide-tab-based-on-pipeline.html

06 May 2025 } } } return v_Pipeline; } Give the argument/parameter "p_DealID" which in this case will be a string. Use the # symbol to map it to "Deals.Deal Id" Save and close the function In the list of functions, hover over the function you just made and select...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *