Morning,
This is not a VB problem - just a general excel one.
If I type in 01793412741 into a cell it always drops off the 0 from the front.
To fix this I put ' in front of it.
The cell then says 01793412741, and in the formula bar it says '01793412741
One machine I use however seems to automatically put the ' infront of everything.
e.g. I type in Hello into A1
A1 says Hello, but the formula bar says 'Hello
Does anyone know what is wrong here - whether or not it is just a setting that I can change.
Thanks in advance
This is not a VB problem - just a general excel one.
If I type in 01793412741 into a cell it always drops off the 0 from the front.
To fix this I put ' in front of it.
The cell then says 01793412741, and in the formula bar it says '01793412741
One machine I use however seems to automatically put the ' infront of everything.
e.g. I type in Hello into A1
A1 says Hello, but the formula bar says 'Hello
Does anyone know what is wrong here - whether or not it is just a setting that I can change.
Thanks in advance