← Back to Blog

Short answer: If iPhone dictation is not working in Numbers, double-tap the cell, then switch to the text keyboard using the buttons above the keys. Numbers has its own number, date and formula keyboards, and none has a mic. If no keyboard appears, tap Edit to leave reading view.

Free to start Dictate into any app on your Mac or iPhone — hold a key, speak, release. Download for MaciPhone

You open a spreadsheet in Numbers on your iPhone to add a note beside a figure, and you would rather say it than peck it out with your thumbs. You tap the cell and look for the mic. There is no keyboard at all. Or a keyboard appears, but it is a pad of large digits with no mic anywhere on it. Or you do manage to dictate a note, and it turns into a date, jumps into the cell below, or ends up half as long as what you said.

Three things about Numbers explain almost all of it. A tap only selects a cell, and a spreadsheet that someone sent you often opens in reading view, where nothing can be edited. When you do open a cell, Numbers may show one of its own keyboards for numbers, dates, durations or formulas, and those are not the iPhone keyboard, so they have no mic key. And once your words arrive, Numbers reads the entry and decides whether it is text, a number or a date.

So most Numbers dictation problems are about the cell and the keyboard Numbers chose for it, not about your microphone. This guide works through every cause in order, starting with the most common. If dictation is failing in every app on your phone and not only in Numbers, start with our complete guide to iPhone dictation not working instead. The same fixes apply to Numbers on iPad.

How dictation reaches Numbers on iPhone

Numbers has no voice typing tool of its own. On iPhone, dictation comes from the keyboard. You open a cell, tap the mic key and speak, and the text arrives at the cursor exactly as if you had typed it. Numbers cannot tell the difference, which is why the same rules apply to spoken and typed entries alike.

That has two consequences. If the keyboard does not appear, there is no mic to tap. And if the keyboard on screen is one of Numbers' own, there is still no mic, because the mic belongs to the iPhone keyboard and Numbers has put its own pad in that keyboard's place. Many "dictation is broken in Numbers" reports are really one of those two situations, and the fix is a tap in the right place, not a change in Settings.

The 30-second Notes test

Before you change anything, open the Notes app, create a new note, tap in the body so the keyboard appears, then tap the mic key and say a sentence.

The 10 fixes, in order

1. Open the cell, do not just select it

A single tap on a cell selects it and draws a border around it. It does not put a cursor in it, so the keyboard stays down and there is no mic. To edit, double-tap the cell, or select it and then tap the keyboard button that appears at the bottom of the screen. The keyboard slides up and a cursor appears for the cell's contents.

Wait until you can see the cursor before you look for the mic. If you tap the mic the instant the keyboard appears, the first words can be lost while the cell is still getting ready. Keep your other fingers off the grid while you talk, too. A tap on another cell moves the selection and ends the edit, which stops dictation mid-sentence.

Cells are small on a phone. If your double-tap keeps landing on the wrong cell, or selects the whole table, pinch to zoom in first so the cell you want is a comfortable target.

2. Switch from the number pad to the text keyboard

This is the cause that is special to Numbers, and it catches people who have dictated happily in every other app. Numbers has several keyboards of its own: a numeric keypad for figures, a keyboard for dates and times, one for durations and one for formulas. They are fast for entering data, but they are built by Numbers, not by iOS, so the mic key you are used to is not on them. A third-party keyboard is not on them either.

Look for the row of buttons that switches between keyboards. In most versions of Numbers it runs along the top of the keyboard, with 123 for the number pad, a clock for dates and times, abc for text and an equals sign for formulas. Tap abc. The standard iPhone keyboard replaces the pad, with the mic key where it always is.

Numbers picks the keyboard it thinks suits the cell, so a cell in a column of figures will usually open on the number pad even when all you want is to add a word. The keyboard can also change back when you move on to the next cell. Make a glance at the keyboard part of your routine: if you see large digit keys, tap abc before you go looking for the mic.

If the cell has been deliberately formatted as a number, a currency or a date and you want words in it, fix 8 explains what happens to them.

3. Tap Edit to leave reading view, and open the file in Numbers

Numbers on iPhone often opens a spreadsheet in reading view, especially one that someone else sent you. Reading view is there to stop accidental changes while you scroll, so taps and double-taps on cells do not bring up a keyboard. Look at the top of the screen. If there is an Edit button, tap it. The toolbar changes, and now a double-tap opens the cell. If the spreadsheet is back in reading view the next time you open it, tap Edit again.

Where the spreadsheet opened matters as well. If you tapped an attachment in Mail, Messages or the Files app, you may be looking at a preview and not at Numbers itself. A preview is for reading only. Use the share button and choose to open the file in Numbers, or open it from inside the Numbers app.

4. Make sure the text keyboard itself has a mic

Once the letters keyboard is showing, the mic should be on it. If it is not, check which keyboard you are actually looking at. If you have more than one installed, the globe key cycles between them, and a long press on it shows the list so you can pick the one you dictate with. Apple's keyboard shows its mic when dictation is enabled. Many third-party keyboards have no mic of their own.

If Apple's keyboard is showing and still has no mic, dictation is switched off or restricted on your iPhone. Fix 10 covers the settings, and our guide to a microphone button missing from the iPhone keyboard goes through every cause in more detail.

5. Unlock the table, and know which cells never take text

If one table refuses every tap while the rest of the sheet behaves, the table may be locked. A locked table cannot be edited until it is unlocked. Select the table, tap the Format button, which looks like a paintbrush, open the Arrange tab and tap Unlock.

Some cells are not text fields at all, whatever you tap:

Text outside a table follows a different rule. A text box, a shape or a chart title needs its own double-tap to get a cursor inside it. A single tap only selects the object, and with an object selected, there is no keyboard.

6. Check that you can edit this spreadsheet

If the spreadsheet opens but no cell will take an entry even after you tap Edit, you may only have permission to look at it. A spreadsheet shared through iCloud can be set to view only, in which case you can read it but not change a word, by typing or by voice. The owner can change your permission so that you can make changes.

When other people are working in the same spreadsheet, their edits and yours travel through iCloud. On a weak connection your entry can take a while to appear for them, and rows can move under you if someone sorts or adds to the table while you are talking. Check that the cell you opened is still the one you meant before you dictate.

Excel files have one more catch. Numbers can open an Excel spreadsheet, but it does so by converting it into a Numbers spreadsheet. Dictation works normally in that converted copy, and the original Excel file is not changed. If a colleague says they cannot see your notes, you probably edited the Numbers copy, and you will need to export it back to Excel and send that.

7. Keep Return and "new line" for the end

In a table, Return does not start a new line. It confirms the entry and moves you on to the next cell. That is exactly what you want when typing figures down a column, and exactly what you do not want in the middle of a dictated sentence. A spoken "new line" can end the entry halfway through your thought, and what follows either lands in the cell below or goes nowhere because dictation stopped when the cell changed.

Dictate each cell as one continuous piece of text. If you really need a line break inside a cell, dictate the first part, tap where you want the break, and use the Insert option in the menu that appears to add a line break by hand. For anything longer than a couple of sentences, a text box on the sheet or a comment is a better home than a cell.

Let dictation finish before you tap Done or tap another cell. If you move on while the last words are still being processed, they can be dropped. Give it a beat after you stop speaking, check the whole entry is there, then confirm.

8. Stop Numbers turning your words into dates and numbers

Unless you tell it otherwise, a cell in Numbers uses an automatic format, which means Numbers looks at each entry and decides what kind of value it is. Dictate "March 3" and you may get a date. Dictate "five percent", which dictation is likely to write as "5%", and Numbers stores a percentage. An ID or a phone number with a leading zero can lose the zero. An entry that begins with an equals sign can open the formula editor.

There is a quick way to see what Numbers decided. With the default alignment, values that Numbers treats as numbers or dates sit on the right of the cell, and text sits on the left. If your note is hugging the right-hand edge, it was converted.

For entries that must stay exactly as you said them, format the cells as text. Select the cells or the whole column, tap the Format button, open the Format tab and choose Text. Everything you dictate into those cells afterwards stays as written. Our guide to dictating numbers, dates and currency covers how to say figures so they come out the way you want.

The opposite problem happens too. Dictation may write a small number as a word, so "five" arrives as text in a column of figures, and a total that uses the column may skip it or show an error. For figures, the number pad is quicker and safer than speaking. Dictation earns its place on the words.

9. Free up the microphone

Dictation needs the microphone to itself. A phone or FaceTime call, a video call in another app, or a recording app still running in the background can all keep hold of it, and dictation may refuse to start until they let go. End the call or stop the recording, then try again.

Headphones are the next suspect. If the mic key does nothing, or dictation starts and gives up at once, disconnect your Bluetooth earbuds or headset and test with the iPhone's own microphone. If that works, the problem is the headset connection, not Numbers. Our guide to iPhone dictation not working with AirPods walks through the headphone side.

10. Check dictation on your iPhone

If dictation failed in Notes too, the problem is on the phone. Open Settings, go to General, then Keyboard, and make sure Enable Dictation is on. If the switch is missing or greyed out, check Screen Time: under Content & Privacy Restrictions, open the allowed apps list and make sure Siri & Dictation is allowed. A work or school iPhone may also restrict dictation through its management profile.

Make sure the keyboard language matches the language you are speaking, since dictation follows the active keyboard. Then install any pending iOS update, update Numbers from the App Store, and if nothing else has worked, restart your iPhone. A restart clears stuck audio sessions and keyboard processes in one step.

Numbers quirks that look like broken dictation

Quick triage

Numbers on iPhone versus Numbers on a Mac

On a Mac, you dictate into Numbers with a keyboard shortcut and not a mic key, and the usual traps are a selected cell with no cursor and Return jumping you down a row. There is one keyboard, so the question of which keyboard is showing never comes up. On iPhone everything runs through the on-screen keyboard, so the first two questions are always whether a keyboard appeared and whether it is the text keyboard. The rest is the same on both: a cell is selected before it is open, Return moves you on, and Numbers decides what your words mean once they arrive. Our guide to Mac dictation not working in Numbers covers the desktop side.

If you also work in other spreadsheet apps on your phone, the same kinds of problems turn up there, with their own twists. We have guides to iPhone dictation not working in Google Sheets and in Excel. For Apple's word processor, see iPhone dictation not working in Pages, which shares Numbers' reading view.

A dictation workflow that suits Numbers on a phone

It is worth getting right, because speaking is much faster than typing. Most adults type around 40 words per minute on a full keyboard, and even professional typists usually sit around 80 to 100, while normal speech runs at 130 to 150 words per minute. On a phone the gap is wider still. That matters in a spreadsheet, where the notes column is often the one that gets skipped, and a sentence of context is the difference between a row someone else can act on and one that only makes sense to you. If you also keep spreadsheets on a computer, our guide on how to dictate in Numbers on a Mac has more on building the habit.

A keyboard with a mic for every text cell

Apple's dictation is free and built in, but it stops when you pause, it depends on settings that are easy to switch off by accident, and fixing a misheard word means going back into the cell and editing by hand on a small screen.

Voice Keyboard Pro is a custom iPhone keyboard with a built-in mic button for dictation in any iOS app, Numbers included. Open a cell, tap abc if Numbers is showing one of its own pads, tap the mic and speak, and your words are added at the cursor. Because it is a keyboard and not a feature of one app, it works the same way in Numbers, Notes, Messages and everywhere else you type. Like any keyboard, it only appears when Numbers is showing the text keyboard, and Numbers still reads your entry as a date, a number or text once it arrives, so fixes 1 to 3 and 5 to 8 still apply.

A few features help with spreadsheets in particular:

Setup means adding the keyboard in Settings and allowing Full Access so it can reach the transcription service. Our guide to enabling Full Access for an iPhone keyboard explains what that permission does. On privacy, our servers store only operational pings. No audio and no transcript content is stored. There is a free tier with daily limits, and Pro is $4.99 a month or $34.99 a year. On a Mac, the same product lives in your menu bar: hold a hotkey, speak, release, and the text appears at your cursor in Numbers or anywhere else.

Frequently asked questions

Does Numbers have voice typing on iPhone?

Not as a feature of its own. You dictate with the mic on your iPhone keyboard, which types into whichever cell is open for editing, exactly as if you had typed the words.

Why is there no microphone on the Numbers keyboard?

You are looking at one of Numbers' own keyboards for numbers, dates, durations or formulas. Those are not the iPhone keyboard, so they have no mic key. Tap the abc button in the row above the keys to switch to the text keyboard, and the mic returns.

Why is there no keyboard when I tap a cell?

A single tap only selects the cell. Double-tap it, or select it and tap the keyboard button. If double-tapping does nothing either, the spreadsheet is in reading view, so tap Edit at the top of the screen, or you have view-only access.

Why did my dictated note turn into a date or a number?

Cells use an automatic format by default, so Numbers converts anything that looks like a date, a number or a percentage. Format the cells as text and your words will stay exactly as you said them.

How do I add a line break inside a cell?

Not with Return or a spoken "new line", which move you on to the next cell. Tap where you want the break and use the Insert option in the menu that appears to add a line break.

Does this work the same way on iPad?

Yes. Numbers on iPad has the same reading view, the same set of keyboards and the same automatic format, so every fix here applies. The keyboard is larger, but the mic key works the same way.

What to do next

Run the 30-second Notes test, then work through the fixes that match what you saw. For most people it is one of the first three: the cell was selected but not open, Numbers was showing its number pad and not the text keyboard, or the spreadsheet was in reading view. If your words arrived but came out as a date or a number, it is fix 8. And if you want dictation that works the same way in every app on your phone, try Voice Keyboard Pro's free tier on your next spreadsheet.

Voice Keyboard Pro
Hold your key · Speak · Release

The words land at your cursor in whatever app you are already in: Numbers, Mail, Slack, a browser form. No dictation window, nothing to copy across.

Free tier with daily limits · Apple Silicon & Intel