vba - stop users typing a 'minus sign' as the first character in a cell...

[RobbieC]

Hi there, I have a spreadsheet for user info entries. This has been working successfully but something has just come to my attention...

If a user enters something into a cell and starts off with a - (minus sign) or = (equals), Excel is expecting some sort of formula to happen and causes an error...

is there a way to detect this and if the first char of any cell (whilst typing) is a - or =, to replace it with a different character?

This would be very helpful if you can point me in the right direction

Thanks

 

[Joe4]

What kind of data is being entered into this range?
If it is not numbers or dates that need to be used later in mathematical computations, if you simply format the column as "Text", they will be able to enter those values in and it won't cause Excel any issues.

 

[RobbieC]

Ah, that's a great idea Joe... I shall make the appropriate changes

Thanks very much

 

[Joe4]

You are welcome!

BTW, you could do what you originally asked via VBA code, but sometimes the best solutions are the simplest!