Hello Everyone,
I have a really annoying problem in my excel.
Every time, I type a number in Excel, it always divide it by 10000 whatever decimal format I put in.
For example, if I type 5, the result in the cell I typed in will be 0.0005.
If I want my excel to have 5 in the cell, I need to type in "5." or "50000".
I don't know why and how is this happen in this pc. Please help me.
Thank you
Last edited by theonea; 02-14-2022 at 01:12 PM.
Welcome to the forum.
No way of knowing without seeing the workbook, but it is probably as a result of some custom formatting or setting.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Click on File - Options, then in the Advanced section at the top, uncheck the option for 'Automatically insert a decimal point'
Rory
This is one of my workbook. Maybe It will help.
Thank you for answering me
Wow that's it. I am headache with this problem for long time.
Thank you so much Rorya.
Glad we could help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks