Text to Speech issues

[Westley]

I just noticed that Excel 2016 reads out financial values incorrectly. When speaking a cell that contains "$276.74" it should say "two hundred seventy six dollars and seventy four cents" but instead it adds an extra 'and' where it does NOT belong, saying "two hundred _and_ seventy six dollars and seventy four cents". When writing a check, I have always been taught to use the word 'and' ONLY between the dollars and the cents, but whoever programmed Excel's text to speech apparently doesn't go by that rule. Is there any way to adjust how Excel speaks cells??

(On a different note, can the voice be changed?? I've changed the voice the Narrator uses, but Excel continues to use the default voice. [shrug])

Thanks!
WesT

 

[Michael M]

I don't know if regional settings will make any difference....but in UK english...the way it is stated, is correct...maybe you need to move countries...LOL !!!

 

[Westley]

I don't know if regional settings will make any difference....but in UK english...the way it is stated, is correct...maybe you need to move countries...LOL !!!

That's interesting...as I do have my keyboard set to UK English. I wonder what other settings may need to be changed.

 

[Westley]

That's interesting...as I do have my keyboard set to UK English. I wonder what other settings may need to be changed.

As you brought it up, I searched for the rule and found an answer at How to Write Out Numbers Using Words on a Check
I'll keep looking (for country differences), but they say:

"And" Replaces the Decimal Point​

Do not use the word "and" after "hundred" or "thousand" if full dollar amounts follow it. The word “and” is only used before the number of cents (in place of the decimal point). In other words, you can use it after the hundreds or thousands, but only if the number of cents follows immediately after. Informally, you may hear people say, “two hundred and five dollars,” but that isn't the correct way to write the number. You may also hear people informally say, "point" in place of the decimal point ("twenty-three point seventy-five"), but that's also technically incorrect.

 

[johnnyL]

Do not use the word "and" after "hundred" or "thousand" if full dollar amounts follow it. The word “and” is only used before the number of cents (in place of the decimal point). In other words, you can use it after the hundreds or thousands, but only if the number of cents follows immediately after.

That is correct! There is an old story about someone offering to to pay One hundred and two thousand dollars for a painting. The seller was shocked when $2,100.00 was received.

 

[Fluff]

On a different note, can the voice be changed??

If you go to the Control Panel (not system settings), Speech recognition, Text to Speech, you can change the voice there.

 

[Westley]

If you go to the Control Panel (not system settings), Speech recognition, Text to Speech, you can change the voice there.

Thanks! That answered that part of the question, but it's still putting in the extra 'and'.
It must have to do with the Language Preferences having both AE and BE. It seems BE takes precedence.

 

[Michael M]

As it should......

 

[SpillerBD]

I just noticed that Excel 2016 reads out financial values incorrectly. When speaking a cell that contains "$276.74" it should say "two hundred seventy six dollars and seventy four cents" but instead it adds an extra 'and' where it does NOT belong, saying "two hundred _and_ seventy six dollars and seventy four cents". When writing a check, I have always been taught to use the word 'and' ONLY between the dollars and the cents, but whoever programmed Excel's text to speech apparently doesn't go by that rule. Is there any way to adjust how Excel speaks cells??

(On a different note, can the voice be changed?? I've changed the voice the Narrator uses, but Excel continues to use the default voice. [shrug])

Thanks!
WesT

There is no fixing or correcting that Text to Speech Error, yet.
It is very annoying. But MS has its own "English".

 

[Michael M]

As I said...nothing to fix really...??