Excel Pro Tips
How to Convert Number to Text with Leading Zeros in Excel
Learn simple Excel methods to convert numbers to text with leading zeros, using TEXT, RIGHT, custom formats, Power Query, and more.
Read article
Author & Spreadsheet Consultant
Tasmia Rahim
268 Articles PublishedPublishing since
Tasmia Rahim holds a B.Sc in Electrical Engineering with a focus on automation and embedded systems, supporting logic-driven spreadsheet workflows. With 2 years of Excel and Google Sheets experience, she works with conditional formatting and basic automation. She is interested in using macros and ActiveX controls to simplify Excel tasks and improve usability.
Editorial Review
Articles Published by Tasmia Rahim
Articles by Tasmia Rahim are developed under the guidance of ExcelInsider’s core training program and are technically reviewed by Nehad Ulfat, lead spreadsheet consultant, to ensure accuracy and user-centric value.
Excel Pro Tips
Format Numbers with Thousands (K) & Millions (M) in Excel
Learn how to format numbers in Excel with “K” for thousands and “M” for millions using custom formatting, TEXT functions, and automated rules.
Read article
Excel Pro Tips
How to Stop Calculating Threads in Excel (4 Simple Ways)
Learn how to stop calculating threads in Excel by disabling multi-threading, using manual mode, limiting threads, or applying VBA fixes.
Read article
Excel Pro Tips
How to Check Excel File Extension (2 Easy Methods)
Learn how to check an Excel file extension using File Explorer or directly within Excel to quickly identify formats like XLS, XLSX, and more.
Read article
Excel Pro Tips
How to Fix Share Workbook Not Showing in Excel
Fix Share Workbook not showing in Excel by adding the legacy command, adjusting Trust Center settings, and using modern co-authoring.
Read article
Excel Pro Tips
How to Sort by Custom List in Excel (with Simple Steps)
Learn how to sort data in Excel using a custom list with clear steps for preparing your dataset, choosing a column, and completing the sort.
Read article
Excel Pro Tips
How to Fix Leading Zero Not Showing in Excel
Learn how to fix leading zeros not showing in Excel using text formatting, custom formats, apostrophes, REPT, LEN, and the TEXT function.
Read article
Excel Pro Tips
How to Convert a Date to Quarter and Year in Excel
Learn how to convert dates to quarter and year in Excel using ROUNDUP, INT, and custom labels for clear, professional quarterly reporting.
Read article
Excel Pro Tips
How to Calculate If Cells Are Not Blank in Excel
Learn how to calculate in Excel when cells are not blank using IF, COUNTBLANK, COUNTA, AND/OR, and ISBLANK for accurate data checks.
Read article
Excel Pro Tips
How to Convert Text with Spaces to Number in Excel
Learn easy Excel methods to convert text with spaces into numbers using SUBSTITUTE, VALUE, CHAR, Text to Columns, and CONCAT techniques.
Read article
Excel Pro Tips
How to Repeat Column Headings on Each Page in Excel
Learn how to repeat column headings on every printed page in Excel using Print Titles, Page Setup adjustments, or a simple VBA solution.
Read article
Excel Pro Tips
How to Automate Data Entry from Another Workbook in Excel
Automate data entry in Excel using simple cell links, dynamic Power Query imports, or fully automated workflows with VBA macros.
Read article