# Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

when i key in \$19.99 i dont want to have to hit the decimal. i would like the cells to know that if there are 4 numbers, the decimal automatically goes 2nd to the right. and if i put 19999, it will key in 199.99
Solved by G. A. in 32 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 01/10/2018 - 08:09
Hi
Excelchat Expert 01/10/2018 - 08:10
Welcome to Excelchat, I see that your question is about fixing the decimal
Excelchat Expert 01/10/2018 - 08:10
I can help you with that problem.
Excelchat Expert 01/10/2018 - 08:10
Before we get started, this is a reminder that our policy is 1 problem per session with additional Q&A on that problem as time allows.
Excelchat Expert 01/10/2018 - 08:10
Let me ask you a couple of quick questions to make sure I fully understand your problem.
User 01/10/2018 - 08:10
Excelchat Expert 01/10/2018 - 08:11
So if i understand correctly when you enter lets say 19999 the cell should show as 199.99
Excelchat Expert 01/10/2018 - 08:11
Is that right?
User 01/10/2018 - 08:12
yes as I mentioned in comments before posting problem
Excelchat Expert 01/10/2018 - 08:12
Ok
Excelchat Expert 01/10/2018 - 08:12
let me have a look and get back to you
User 01/10/2018 - 08:12
Sure
Excelchat Expert 01/10/2018 - 08:14
Give me sometime
Excelchat Expert 01/10/2018 - 08:14
It doesnt look like it can be done directly
User 01/10/2018 - 08:14
ok, then?
Excelchat Expert 01/10/2018 - 08:15
I am trying some custom formatting
Excelchat Expert 01/10/2018 - 08:15
let me see if that works
User 01/10/2018 - 08:15
ok, let me know
Excelchat Expert 01/10/2018 - 08:17
It will take some time as I am trying to explore a lot of options
Excelchat Expert 01/10/2018 - 08:17
I hope you dont mind that
User 01/10/2018 - 08:18
how much time will it take?
Excelchat Expert 01/10/2018 - 08:18
at least 10 mins
User 01/10/2018 - 08:18
no problem, I have meeting coming up, that will be cool to have in 10 minutes
User 01/10/2018 - 08:19
Excelchat Expert 01/10/2018 - 08:19
Sorry I cannot discuss personal information
User 01/10/2018 - 08:19
I'm henry
User 01/10/2018 - 08:19
ok
Excelchat Expert 01/10/2018 - 08:19
I am not allowed to do that
Excelchat Expert 01/10/2018 - 08:21
Ok
Excelchat Expert 01/10/2018 - 08:22
So I did research a bit
Excelchat Expert 01/10/2018 - 08:22
and it doesnt look like that I can help you with a conditional formattiing
Excelchat Expert 01/10/2018 - 08:22
but i can help you with a formula to do that
User 01/10/2018 - 08:23
whats that
Excelchat Expert 01/10/2018 - 08:23
For example if you enter 1999 in cell B2
Excelchat Expert 01/10/2018 - 08:23
it would format that to 19.99
Excelchat Expert 01/10/2018 - 08:23
and so on and so forth
Excelchat Expert 01/10/2018 - 08:23
Let me know if that helps
User 01/10/2018 - 08:24
What is the formula
Excelchat Expert 01/10/2018 - 08:24
you can use a text formula
Excelchat Expert 01/10/2018 - 08:25
TEXT(B2/100,"#####.00")
Excelchat Expert 01/10/2018 - 08:25
This formula divides your number by 100 and makes sure that it adds only 2 decimal places after the division
User 01/10/2018 - 08:25
no no
User 01/10/2018 - 08:25
I don't want this
Excelchat Expert 01/10/2018 - 08:26
I am really sorry
User 01/10/2018 - 08:26
when ever I input any number in my excel file it shows with decimal. suppose I'm inputting 2999 in a1 it is auto calculating to 29.99
Excelchat Expert 01/10/2018 - 08:27
Oh
User 01/10/2018 - 08:27
formula will not help me
Excelchat Expert 01/10/2018 - 08:27
ok
Excelchat Expert 01/10/2018 - 08:27
I got the question other way
Excelchat Expert 01/10/2018 - 08:27
Is it possible for you to share the workbook with me?
User 01/10/2018 - 08:27
sorry it is confidential and against my business policy
User 01/10/2018 - 08:27
i may respond slow due to meeting
Excelchat Expert 01/10/2018 - 08:27
Sure
Excelchat Expert 01/10/2018 - 08:28
Nota problem
Excelchat Expert 01/10/2018 - 08:28
can you delete all the records except one and share the workbook
User 01/10/2018 - 08:28
you please provide the solution and i will respond you back slowly slowly
Excelchat Expert 01/10/2018 - 08:28
also you can change the number for that record
User 01/10/2018 - 08:28
i cant
Excelchat Expert 01/10/2018 - 08:30
I am really sorry but without having a look and the excel i wont be able to solve the problem
User 01/10/2018 - 08:30
it happened with me couple of weeks or may be month back, one of your expert helped me perfectly
User 01/10/2018 - 08:30
i also didn't shared the workbook
Excelchat Expert 01/10/2018 - 08:30
Oh in that case you can find that solution in the chat sessions
Excelchat Expert 01/10/2018 - 08:31
You can see all the sessions in your history
Excelchat Expert 01/10/2018 - 08:31
you will have the solution there
User 01/10/2018 - 08:31
ok
Excelchat Expert 01/10/2018 - 08:31
I am really sorry that I could not help you with it
User 01/10/2018 - 08:32
its ok, can i please have that expert again? he was super awesome
Excelchat Expert 01/10/2018 - 08:32
It is the system that posts the questions to the experts
Excelchat Expert 01/10/2018 - 08:32
But i can suggest you to end this session and try again
Excelchat Expert 01/10/2018 - 08:33
with another expert
Excelchat Expert 01/10/2018 - 08:33
I am really sorry about that
User 01/10/2018 - 08:33
ok bye
User 01/10/2018 - 08:33
will check that
Excelchat Expert 01/10/2018 - 08:34
Thanks have a nice day!
Excelchat Expert 01/10/2018 - 08:38
Hi, Are you there?
User 01/10/2018 - 08:40
yes
Excelchat Expert 01/10/2018 - 08:40
Could you please end the session from your end?
User 01/10/2018 - 08:40
there is no end option here
Excelchat Expert 01/10/2018 - 08:41
oh ok
Excelchat Expert 01/10/2018 - 08:41
Do you have it now?
User 01/10/2018 - 08:41
ya

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

## Click here to get your free Excelchat help session

Trusted by people who work at