**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

please ask

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

whats your name

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.*