Cell formatting as I type

[antmanmom92]

Hi, I need to know if this is possible. I need to type a number in a cell (.456) and have it displayed as (.123). Help!

[MaczaQ]

Because your problem is quit poor explained I provide something like this

Please Login or Register  to view this content.

Place this code in ThisWorkbook code section

[antmanmom92]

Thank you for this information but I'm going to try and explain this a little better.

I have a chart, 3 columns. In the first cell of the first column, I want to type in an actual measure of .786 but what i want to show up in the cell is actually the result of .786 MINUS .250. So what i want to show in the column where I typed .786 is .536.

Does this help?

[MaczaQ]

is it possible to attach any sample workbook with dummy data ?
It will be better for imagine what are you looking for.

[antmanmom92]

Thank you for your help with this. We got it solved with a work-around that involved adding additional columns, getting the results we wanted after using a formula string, and then deleting the extra columns.

Thanks again!

[Cutter]

@ antmanmom92

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[antmanmom92]

Thank you Cutter! Now that my problem is solved, perhaps I can spend a little time reviewing the forum rules! I was in a hurry for a solution at the time I joined. Thanks again!