LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
xlcj
 
Posts: n/a
Default Why do I get repetitions of characters in my cells?

I have a large workbook with lots of macros that has worked well for a
couple years. Suddenly, any text or number I type or copy into any cell
within a certain column repeats itself to as many repetitions as is
viewable, depending on the column width. So if the column is wide enough to
show three characters and I type CAT, but then drag the column wider, I
would get CATCAT, then CATCATCAT, etc. The cell edit box only shows CAT, and
math still works OK, so it may be more of a view or display problem than a
cell contents problem. I read about using an asterisk as a repetition
initiator when using a custom cell format, but these cells just have a
general format. Maybe there is some setting I have accidentally initiated,
or maybe my macros are rebelling.

Sorry if I'm the 99th person to ask about this, but it has me stumped.
Thanks.
Carl


 
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
Add the same character(s) to multiple cells in a column (or row) . flashcatj Excel Discussion (Misc queries) 6 April 22nd 23 06:09 AM
find cells that contain specific characters mshornet Excel Worksheet Functions 8 November 23rd 05 02:02 PM
need to add/remove characters over thousands of cells Nadia Excel Discussion (Misc queries) 3 June 19th 05 11:38 PM
Heps to design Locked/Unlocked cells in protected worksheet Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:09 AM
linking cells in Excel 2003. How to not truncate to 255 characters. GarryFerg Excel Discussion (Misc queries) 5 December 8th 04 03:33 PM


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

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"