SOLVED
Home

No One Seems to Know The Answer...Can you help with this "Simple" Excel issue? Please pretty please.

%3CLINGO-SUB%20id%3D%22lingo-sub-853332%22%20slang%3D%22en-US%22%3ERe%3A%20No%20One%20Seems%20to%20Know%20The%20Answer...Can%20you%20help%20with%20this%20%22Simple%22%20Excel%20issue%3F%20Please%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-853332%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F408105%22%20target%3D%22_blank%22%3E%40helpfuld%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20a%20Windows%20user%20but%20I%20am%20sure%20that%20you%20need%20to%20change%20the%20regional%20setting%20for%20changing%20the%20decimal%20separator%20and%20the%20date%20format.%3C%2FP%3E%3CP%3EYou%20may%20change%20them%20in%20your%20System%20Preferences%20--%26gt%3B%20Language%20%26amp%3B%20Region%20--%26gt%3B%20Advanced%20--%26gt%3B%20and%20in%20there%2C%20you%20may%20change%20the%20decimal%20separator%20from%20comman%20to%20a%20period%20and%20date%20format%20as%20per%20your%20requirement.%3C%2FP%3E%3CP%3EWhen%20you%20input%209%2F2%2C%20Excel%20takes%209%20as%20month%20and%202%20as%20day%20and%20it%20returns%202%2F9%20which%20would%20be%20equivalent%20to%20the%202nd%20September.%20Try%20to%20insert%20a%20year%20also%20and%20see%20what%20date%20do%20you%20get.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-853358%22%20slang%3D%22en-US%22%3ERe%3A%20No%20One%20Seems%20to%20Know%20The%20Answer...Can%20you%20help%20with%20this%20%22Simple%22%20Excel%20issue%3F%20Please%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-853358%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F394231%22%20target%3D%22_blank%22%3E%40Subodh_Tiwari_sktneer%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20very%20much%20for%20the%20response.%20Your%20response%20helped%20me%20to%20solve%20the%20date%20issue%2C%20but%20the%20other%20problem%20with%20the%2012.95%20amount%20is%20still%20not%20working.%26nbsp%3B%20When%20I%20put%2012.95%20it%20is%20changing%20it%20to%20this%20weird%20.5697%3F%20Any%20idea%20how%20to%20fix%20that%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-853207%22%20slang%3D%22en-US%22%3ENo%20One%20Seems%20to%20Know%20The%20Answer...Can%20you%20help%20with%20this%20%22Simple%22%20Excel%20issue%3F%20Please%20pretty%20please.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-853207%22%20slang%3D%22en-US%22%3E%3CP%3ESee%202%20min%20video%20and%20you'll%20understand.%3C%2FP%3E%3CP%3Evideo%3A%20...%3CBR%20%2F%3E%3CBR%20%2F%3E2%20people%20said%20they%20thought%20it%20looked%20like%26nbsp%3Bthe%20%22automatically%20insert%20a%20decimal%20point%22%20is%20enabled%20if%20on%20a%20PC%20and%20it%20needs%20to%20be%20unselected%2Funchecked.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EBut%20on%20Mac%20when%20I%20hit%26nbsp%3B%20%22Command%2C%22%20and%20go%20to%20edit%20it%20shows%20that%20the%20%22display%20this%20number%20of%20decimals%22%20is%20not%20selected%20by%20default.%20Is%20there%20somewhere%20else%20I%20need%20to%20go%2C%20different%20setting%3FI%20am%20on%20a%20Mac%20using%20Excel%20version%2016.28If%20anyone%20knows%20what%20issue%20is%20and%20how%20to%20fix%2C%20I%20would%20be%20so%20grateful%2C%20this%20is%20driving%20me%20nuts%20for%20sure.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-853207%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-853363%22%20slang%3D%22en-US%22%3ERe%3A%20No%20One%20Seems%20to%20Know%20The%20Answer...Can%20you%20help%20with%20this%20%22Simple%22%20Excel%20issue%3F%20Please%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-853363%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F394231%22%20target%3D%22_blank%22%3E%40Subodh_Tiwari_sktneer%3C%2FA%3E%26nbsp%3B%20Actually%2C%20that%20was%20weird%2C%20it%20was%20not%20working%20for%20the%2012.95%20issue%2C%20but%20now%20it%20seems%20to%20be%20working.%20I%20just%20deleted%20those%20cells%20and%20now%20it%20works%20when%20I%20type%2012.95%20it%20actually%20stays%20as%2012.95.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20think%20issue%20is%20solved.%20So%20for%20mac%20I%20had%20to%20change%20my%20actual%20Mac%20settings.%20It%20was%20on%20Indonesia%2C%20instead%20of%20US%20because%20I%20got%20computer%20repaired%20in%20Bali%20like%202%20years%20ago%20and%20those%20guys%20must've%20changed%20my%20setting%20and%20never%20put%20it%20back.%20Craziness.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22p1%22%3E%3CSTRONG%3EFor%20Mac%20OS%20version%2010.10.1%2C%20please%20follow%20these%20instructions%3A%3C%2FSTRONG%3E%3C%2FP%3E%3COL%3E%3CLI%3EClose%20the%20Excel%20application%3C%2FLI%3E%3CLI%3EClick%20on%20the%20Apple%20button%3C%2FLI%3E%3CLI%3ESelect%26nbsp%3B%3CSTRONG%3ESystem%20Preferences%3C%2FSTRONG%3E%3C%2FLI%3E%3CLI%3ESelect%3CSTRONG%3E%26nbsp%3BLanguage%26nbsp%3Band%20Region%3C%2FSTRONG%3E%3C%2FLI%3E%3CLI%3EClick%3CSTRONG%3E%26nbsp%3BAdvanced%3C%2FSTRONG%3E%3C%2FLI%3E%3CLI%3EChange%20the%26nbsp%3B%3CSTRONG%3EDecimal%3C%2FSTRONG%3E%26nbsp%3Bseparator%20from%20a%26nbsp%3B%3CSTRONG%3Ecomma%20(%2C)%3C%2FSTRONG%3E%26nbsp%3Bto%20a%3CSTRONG%3E%26nbsp%3Bfull%20stop%20(.)%3C%2FSTRONG%3E%3C%2FLI%3E%3CLI%3EThen%20click%20on%26nbsp%3B%3CSTRONG%3EOk%2FSave%3C%2FSTRONG%3E%3C%2FLI%3E%3CLI%3E%3CSTRONG%3ETest%20the%20Excel%20import%20again%3C%2FSTRONG%3E%3C%2FLI%3E%3C%2FOL%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-853381%22%20slang%3D%22en-US%22%3ERe%3A%20No%20One%20Seems%20to%20Know%20The%20Answer...Can%20you%20help%20with%20this%20%22Simple%22%20Excel%20issue%3F%20Please%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-853381%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F408105%22%20target%3D%22_blank%22%3E%40helpfuld%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGreat!%20Glad%20your%20issue%20has%20been%20fixed.%3C%2FP%3E%3CP%3EPlease%20accept%20the%20post%20with%20the%20proposed%20solution%20as%20an%20Accepted%20Answer%20to%20mark%20your%20question%20as%20Solved.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-853460%22%20slang%3D%22en-US%22%3ERe%3A%20No%20One%20Seems%20to%20Know%20The%20Answer...Can%20you%20help%20with%20this%20%22Simple%22%20Excel%20issue%3F%20Please%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-853460%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F394231%22%20target%3D%22_blank%22%3E%40Subodh_Tiwari_sktneer%3C%2FA%3E%26nbsp%3BI%20marked%20your%20post%20as%20best%20response.%20I%20do%20not%20see%20anywhere%20to%20accept%20as%20answer%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-853477%22%20slang%3D%22en-US%22%3ERe%3A%20No%20One%20Seems%20to%20Know%20The%20Answer...Can%20you%20help%20with%20this%20%22Simple%22%20Excel%20issue%3F%20Please%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-853477%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F408105%22%20target%3D%22_blank%22%3E%40helpfuld%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%20Marking%20a%20post%20as%20Best%20Response%20is%20same%20as%20accepting%20a%20post%20as%20an%20Answer.%3C%2FP%3E%3C%2FLINGO-BODY%3E
helpfuld
New Contributor

See 2 min video and you'll understand.

video: ...

2 people said they thought it looked like the "automatically insert a decimal point" is enabled if on a PC and it needs to be unselected/unchecked. 

But on Mac when I hit  "Command," and go to edit it shows that the "display this number of decimals" is not selected by default. Is there somewhere else I need to go, different setting?

I am on a Mac using Excel version 16.28

If anyone knows what issue is and how to fix, I would be so grateful, this is driving me nuts for sure.

6 Replies
Solution

@helpfuld 

I am a Windows user but I am sure that you need to change the regional setting for changing the decimal separator and the date format.

You may change them in your System Preferences --> Language & Region --> Advanced --> and in there, you may change the decimal separator from comman to a period and date format as per your requirement.

When you input 9/2, Excel takes 9 as month and 2 as day and it returns 2/9 which would be equivalent to the 2nd September. Try to insert a year also and see what date do you get.

Highlighted

@Subodh_Tiwari_sktneer 

 

Thank you very much for the response. Your response helped me to solve the date issue, but the other problem with the 12.95 amount is still not working.  When I put 12.95 it is changing it to this weird .5697? Any idea how to fix that?

@Subodh_Tiwari_sktneer  Actually, that was weird, it was not working for the 12.95 issue, but now it seems to be working. I just deleted those cells and now it works when I type 12.95 it actually stays as 12.95.

I think issue is solved. So for mac I had to change my actual Mac settings. It was on Indonesia, instead of US because I got computer repaired in Bali like 2 years ago and those guys must've changed my setting and never put it back. Craziness. 

 

For Mac OS version 10.10.1, please follow these instructions:

  1. Close the Excel application
  2. Click on the Apple button
  3. Select System Preferences
  4. Select Language and Region
  5. Click Advanced
  6. Change the Decimal separator from a comma (,) to a full stop (.)
  7. Then click on Ok/Save
  8. Test the Excel import again

@helpfuld 

Great! Glad your issue has been fixed.

Please accept the post with the proposed solution as an Accepted Answer to mark your question as Solved.

@Subodh_Tiwari_sktneer I marked your post as best response. I do not see anywhere to accept as answer?

@helpfuld 

Thanks! Marking a post as Best Response is same as accepting a post as an Answer.

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
23 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies