ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Help - every cell starts with ' r ^ in the formula line! (https://www.excelbanter.com/excel-discussion-misc-queries/135057-help-every-cell-starts-r-%5E-formula-line.html)

SSB

Help - every cell starts with ' r ^ in the formula line!
 
For some reason every cell that I write something in has a ' or a ^ or a " at
the beginning of the text. This is only visible in the formula bar or when I
doubleclick the cell to enter or copy texts.

How can I prevent this - it's VERY annoying!
Thanks for your help!

BoniM

Help - every cell starts with ' r ^ in the formula line!
 
Tools, options, transition tab, transition navigation keys is apparently
turned on. This is placing Lotus alignment codes at the beginning of each
cell.
' (apostrophe) Left align data in the cell
" (quotation mark) Right align data in the cell
^ (caret) Center data within the cell


"SSB" wrote:

For some reason every cell that I write something in has a ' or a ^ or a " at
the beginning of the text. This is only visible in the formula bar or when I
doubleclick the cell to enter or copy texts.

How can I prevent this - it's VERY annoying!
Thanks for your help!



All times are GMT +1. The time now is 05:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com