apostrophies to view all text

stickboy

Board Regular
Joined
Jun 23, 2002
Messages
84
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
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
On the machine that puts the ' in front of everything choose Tools, Options and on the Transition tab uncheck Transition navigation keys.

To always show the leading zero in an entry such as 01793412741 format the cell as 00000000000.
 

Forum statistics

Threads
1,144,117
Messages
5,722,576
Members
422,446
Latest member
srclife

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top