Formula Entry

[dauds]

For the sum of the numbers in a single cell i know you need to key in =12+15 to get the sum. But is there a way to format the cell so that all I need to is key in 12+15 and it automatically does the calculation?

Cheers

[shg]

Welcome to the forum.

Formulas in Excel begin with =. For legacy compatibility, they can instead begin with + or -. That's it.

Please take a few minutes to read the forum rules about thread titles before posting again.

Thanks.

[DonkeyOte]

As shg has already outlined you can't do this without the use of VBA, a very basic example being:

Please Login or Register  to view this content.

to insert the above - right click on Tab against which this process is to be applied and select View Code pasting above into resulting window.

Thereafter in a Macro enabled file when an entry is made into the range specified (A1:A1000 - modify as required) the code will convert as appropriate.