Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
SSB SSB is offline
external usenet poster
 
Posts: 1
Default 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!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 353
Default 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!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula starts =+(cell reference) chaunceycupoo Excel Discussion (Misc queries) 3 September 28th 06 08:19 PM
One line starts higher than others Sloth Excel Discussion (Misc queries) 3 August 24th 06 06:35 PM
Delete row if cell starts with ........... mohd21uk via OfficeKB.com New Users to Excel 2 May 15th 06 05:50 PM
formula starts : =+ what does plus indicate? pskwaak Excel Worksheet Functions 3 February 24th 06 02:46 AM
if cell starts with characters formula Norman Kong via OfficeKB.com Excel Discussion (Misc queries) 3 March 24th 05 10:18 AM


All times are GMT +1. The time now is 06:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"