
How to Generate Random Numbers Between a Range in Excel
Learn 5 easy ways to generate random numbers in Excel using RANDBETWEEN, RAND, RANDARRAY, VBA, and the Data Analysis Toolpak.

Nusrat Jahan holds a BSc in Computer Science & Engineering from North South University and has 4+ years of Excel and Google Sheets experience. She specializes in data analysis, visualization, formulas, PivotTables, charts, data cleaning, validation, and IMPORTRANGE. She enjoys creating habit trackers, budget planners, and project management sheets, using formulas, conditional formatting, and interactive tools to simplify task organization and financial planning.
Articles by Nusrat Jahan 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.

Learn 5 easy ways to generate random numbers in Excel using RANDBETWEEN, RAND, RANDARRAY, VBA, and the Data Analysis Toolpak.

Learn how to convert hex to decimal in Excel using HEX2DEC, the DECIMAL function, or a custom VBA function for advanced use.

Learn how to change comma styles in Excel to US or Indian format, format negative numbers, and use the Comma Style button easily.