Show formatting marks
On my boss's computer, a WinXP Pro machine with O2K, if he enters a single '
mark before a number, it is stored as text. This is useful when storing numbers with leading zeros, such as UPC numbers. If we look at a number stored as text, the ' mark appears in the formula bar, just to the left of the number. Like this: '031655123450 But if I open the same workbook in my computer (also WinXP Pro with O2k), the mark does not appear, even though the number is still in text format. In fact, if I enter a ' mark in MY copy of Office, the format is changed to text, but the mark disappears. My question is: How can I set my copy of Excel to show the formatting marks? -- GateKeeper Experienced Computer User |
Show formatting marks
I've always been able to see that apostrophe if I type it myself.
But if I format the cell as Text, then I can't--well, unless I toggle this setting: Tools|Options|Transition tab check Transition navigation keys But be prepared for differences in other stuff. Home, ctrl-home, Ctrl-End, tab, shift-tab all work differently under this setting. I only toggle that setting for a little while, then I toggle it off. GateKeeper wrote: On my boss's computer, a WinXP Pro machine with O2K, if he enters a single ' mark before a number, it is stored as text. This is useful when storing numbers with leading zeros, such as UPC numbers. If we look at a number stored as text, the ' mark appears in the formula bar, just to the left of the number. Like this: '031655123450 But if I open the same workbook in my computer (also WinXP Pro with O2k), the mark does not appear, even though the number is still in text format. In fact, if I enter a ' mark in MY copy of Office, the format is changed to text, but the mark disappears. My question is: How can I set my copy of Excel to show the formatting marks? -- GateKeeper Experienced Computer User -- Dave Peterson |
All times are GMT +1. The time now is 01:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com