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.

@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?

Highlighted

@helpfuld 

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

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