Enter one value, then check it
Select a blank measurement cell, click into the cell or formula bar so a text cursor is visible, and start dictation. Say a short value such as “seventeen point eight”. Stop dictation, check the result, and press Enter. Confirm that Excel recorded the number you intended before moving on.
For repeated measurements, also check the record ID and column heading. A correctly transcribed value in the wrong row is still an incorrect entry.
Give each measurement a clear place
Before you start, separate record IDs, measurements, and notes into clearly labelled columns. Keep values used in calculations numeric. Put the unit in the heading when it is the same for every row, or use a separate unit column when it varies.
Lab sample
Sample B-204 has a temperature of −12.5 °C. Use columns such as Sample ID, Temperature (°C), and Status. Enter −12.5 in the temperature cell.
Manufacturing inspection
Inspection QC-127 records a part diameter of 17.8 mm. Use a unique Inspection ID, Diameter (mm), and Result. Enter 17.8 in the diameter cell.
An inspection ID is useful when the same part appears in several rows. It tells you which individual inspection you are updating.
Start voice entry on Windows or Mac
Windows
Windows key + H
Put the Excel cell into edit mode, then press Windows key + H. Wait for the listening indicator before speaking. Windows Voice Typing needs a microphone and an internet connection.
macOS
Your Dictation shortcut
Enable Dictation in System Settings → Keyboard and check its shortcut. Click inside the Excel cell or formula bar, then use that shortcut. If Voice Control is on, use its dictation features instead.
For full setup instructions, see our speech-to-text guide for Excel. If nothing appears when you speak, follow the Windows and Mac troubleshooting guide.
For moving between entries, see our guide to navigating Excel by voice and updating records with Lucy.
Make the decimal and minus sign explicit
For English dictation, try “seventeen point eight” for 17.8 and “minus twelve point five” for −12.5. Speak the fractional digits separately for a value such as 17.08: “seventeen point zero eight”. These are starting phrases, not commands guaranteed to work in every speech tool or language.
Try a positive value, a negative value, and a decimal in a blank workbook first. Check for missing signs, extra spaces, or numbers written as words. If the speech tool adds punctuation, review its automatic-punctuation setting, where available.
Check whether your worksheet uses a point or comma
The examples here use a decimal point. Your Excel settings may use a decimal comma, so the same measurement would appear as 17,8. Check the result under your own settings; do not assume that punctuation in the transcript will be interpreted as you expect.
Microsoft explains decimal and thousands separators in Excel for Windows. Changing those settings affects more than voice entry, so confirm the convention used by your team before making a change.
Keep the number usable in calculations
For a column labelled Diameter (mm), dictate the number alone. A cell containing “17.8 millimetres” may be stored as text rather than a numeric measurement. Keeping 17.8 in the measurement column and mm in the heading makes the intended unit clear.
If your sheet has separate Value and Unit columns, fill them separately with ordinary dictation. Speaking both in one phrase will not reliably put them into two cells. Use the unit expected by the worksheet: changing a label from cm to mm does not convert the measurement.
For an existing lab or inspection log, follow its established layout and unit convention. Agree any changes with the people who use the sheet.
Treat identifiers as labels
An ID such as 00127 identifies a record; it is not a quantity. Format a blank ID column as Text before entering identifiers so Excel can retain leading zeros. This does not restore zeros that have already been removed.
Read back the full ID after dictation, including letters, hyphens, and zeros. Text formatting preserves what reaches the cell, but cannot correct a misheard identifier. Microsoft documents the available options for keeping leading zeros in Excel.
Keep measurement columns numeric. Formatting the entire sheet as Text to protect IDs can cause problems with calculations elsewhere.
Check the record, value, and unit together
- 1Confirm the row and column. Check the sample or inspection ID and the measurement heading before entering the next result.
- 2Review the full number. Check the sign, decimal position, and every digit against the reading. Correct a misheard value before continuing.
- 3Check the unit. Make sure the instrument reading and worksheet use the same unit, especially if you work with several instruments.
- 4Look beyond the displayed decimal places. A cell showing 17.8 may contain 17.84 with a one-decimal format. Check the formula bar when the displayed value seems rounded.
Under normal number formatting, changing the displayed decimal places does not change the stored value. Microsoft explains this distinction in its number-format guidance. Follow your measurement procedure for precision and rounding; the appearance of a cell does not establish either.
When natural-language entry is a better fit
Dictation is useful when you have already selected the cell and want to enter a value. At a lab bench or inspection station, selecting the right row and moving between fields may take as much attention as typing the number.
Lucy is designed for updates to existing records. After setting up the worksheet and starting a listening session, you name the record, field, and value in your instruction. Lucy resolves those targets against the worksheet and reports the outcome of each update.
Example: temperature and status
“For sample B-204, set temperature to minus twelve point five and status to needs review.”
Assume B-204 already exists, with a Temperature (°C) field and a Status field. The intended changes are a temperature of −12.5 and a status of Needs review.
With ordinary dictation
Find B-204, select its temperature cell, and dictate the value. Then move to Status and dictate the note. Saying the whole instruction at once may put it all into one cell.
With Lucy
The instruction can produce two independent updates for the named sample. Review whether each was applied, skipped, or failed. If the target cannot be resolved safely, Lucy skips the update with a reason.
The same approach suits an inspection: “For inspection QC-127, set diameter to seventeen point eight and result to needs review.” The worksheet should already specify that diameter is measured in millimetres. Use an inspection ID that identifies a single record.
The advantage is being able to name the record and several fields without clicking each destination. It does not guarantee better recognition of every number. Review the values and update outcomes, and do not assume that units will be converted or measurements rounded for you.
Questions about entering numbers by voice
Can I dictate numbers directly into Excel?
Yes. Place a text cursor in an editable cell or the formula bar and use Windows Voice Typing or macOS Dictation. Check the result before moving to the next cell, particularly the sign and decimal separator.
How should I say a decimal or negative number?
In English, try phrases such as “seventeen point eight” or “minus twelve point five”. The wording and result depend on your speech tool and language. Try a few values in a blank workbook before entering measurements.
Should I say the unit with the number?
For a numeric measurement column, enter the value alone and keep the unit in the header or a separate column. Dictating “17.8 millimetres” into one cell may create text that your calculations cannot use as a number.
Will Lucy convert units or round measurements for me?
Do not assume automatic conversion or rounding. Use the unit specified in your worksheet and give the value at the precision you need. Lucy’s role in the examples here is to identify the existing record and fields to update.
For speech-tool settings and supported punctuation, see Microsoft Voice Typing help and Apple Dictation commands. Available commands depend on your language and operating system.