KnowBrainer Speech Recognition
Decrease font size
Increase font size
Topic Title: Dated not being inputted correctly in Excel
Topic Summary: 10 March 2020 instead of 3 October 2020
Created On: 10/03/2020 04:26 PM
Status: Post and Reply
Linear : Threading : Single : Branch
 Dated not being inputted correctly in Excel   - tnortham2919 - 10/03/2020 04:26 PM  
 Dated not being inputted correctly in Excel   - kkkwj - 10/03/2020 05:01 PM  
 Dated not being inputted correctly in Excel   - tnortham2919 - 10/05/2020 10:22 AM  
 Dated not being inputted correctly in Excel   - Jomark - 10/06/2020 07:12 AM  
 Dated not being inputted correctly in Excel   - kkkwj - 10/06/2020 11:55 AM  
Keyword
 10/03/2020 04:26 PM
User is offline View Users Profile Print this message

Author Icon
tnortham2919
Junior Member

Posts: 26
Joined: 11/16/2017

I am using Excel. In the cell I have formatted whatever is going to be inputted as a date and the type I have chosen is 14 March 2012 - in the drop down list. 

The location I have chosen is English (United Kingdom). I am using the latest version of office 365.

 

When I type 03/10/2020 with my fingers I get what is expected which is 03 October 2020.

When I input the same using my voice I get 10 March 2020, which is not what I want. 

 

If I go to the settings in Excel.

1. the office "office display language" and "authoring languages and proofing" are set to English (United Kingdom)

2. In proofing the dictionary language is set to English United Kingdom



-------------------------
Thank you
 10/03/2020 05:01 PM
User is offline View Users Profile Print this message

Author Icon
kkkwj
Top-Tier Member

Posts: 801
Joined: 11/05/2015

It looks like the month and day are reversed - 03 10 2020 becomes 10 03 2020.
When you enter the value by voice, do you use slashes?


If it helps any, I use voice all the time to enter dates in excel without a problem. But I'm using the 2020-10-03 format, and I say "twenty twenty hyphen ten hyphen zero three."

-------------------------

Win10/x64, AMD Ryzen 7 3700X, 64GB RAM, Dragon 15.3, SP 6 PRO, SpeechStart, Office 365, KB 2017, Dragon Capture, Samson Meteor USB Desk Mic, Klim and JUKSTG earbuds with microphones, 3 BenQ 2560x1440 monitors, Microsoft Sculpt Keyboard and fat mouse

 10/05/2020 10:22 AM
User is offline View Users Profile Print this message

Author Icon
tnortham2919
Junior Member

Posts: 26
Joined: 11/16/2017

Hi, yes I am using slashes. However if I'm using hyphens the same happens. So if I enter 02-10-2020 using my voice, and utter 'apply', I get 10/02/2020 when what I want is 02/10/2020.

If I type 02-10-2020 with my hands and press return using my hands I get 02/10/2020, which is what I'm looking for. However, I want to do this using my voice, not my hands.

-------------------------
Thank you
 10/06/2020 07:12 AM
User is offline View Users Profile Print this message


Jomark
Top-Tier Member

Posts: 1503
Joined: 10/19/2006

If I dictate “five October twenty twenty” into a cell then I get “5 October 2020”. If the cell formatting is in the form “14/03/2012” and I move to the next cell, I get “05/10/2020”.

If I dictate in the format that you described, then I get exactly the same as you and the dates are shown in the American date format. I also tried looking at the auto formatting options in Dragon but it did not seem to make any difference. I also checked the preferred language for Excel and my preferred language is English UK.

I am using Microsoft Office 2019.



-------------------------

Jomark


 


DPI 15.61, KB2017, SpeechStart+, MS Office 2019 Professional, Windows 10 Pro

 10/06/2020 11:55 AM
User is offline View Users Profile Print this message

Author Icon
kkkwj
Top-Tier Member

Posts: 801
Joined: 11/05/2015

Maybe your Windows regional date format settings are different than Excel are different than Dragon? My regional settings match the Excel date format settings.

-------------------------

Win10/x64, AMD Ryzen 7 3700X, 64GB RAM, Dragon 15.3, SP 6 PRO, SpeechStart, Office 365, KB 2017, Dragon Capture, Samson Meteor USB Desk Mic, Klim and JUKSTG earbuds with microphones, 3 BenQ 2560x1440 monitors, Microsoft Sculpt Keyboard and fat mouse

Statistics
32132 users are registered to the KnowBrainer Speech Recognition forum.
There are currently 0 users logged in.
The most users ever online was 12124 on 09/09/2020 at 04:59 AM.
There are currently 448 guests browsing this forum, which makes a total of 448 users using this forum.

FuseTalk Standard Edition v4.0 - © 1999-2021 FuseTalk™ Inc. All rights reserved.