Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
mshanaha
 
Posts: n/a
Default Invisible Text designation in cell?

Using paste special of a formula (values) and replace all, spreadsheet
developed annoying habit of only working in the first cell of range and
remainder seem to be text only fields even though there was no format for
text on the cell.

Deleting cells and repasting did not help.

Pasting elsewhere did not help.

Workaround was redeveloping underlying formula for pasting which is
extremely time consuming. Have never seen this before.

Any suggestions ????
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
Why doesn't text wrap in a cell in Excel? rohrbaught Excel Discussion (Misc queries) 6 April 8th 05 06:13 PM
Autofitting a row Josephine Excel Discussion (Misc queries) 2 March 3rd 05 04:37 PM
Text wider than one cell is not displayed in the next empty cell Len Pace Excel Discussion (Misc queries) 5 February 18th 05 01:24 AM
Link the value to text in a cell, then use that text cell in a for acpharmd Excel Worksheet Functions 6 December 29th 04 03:03 AM
Forcing text onto new line in cell Doug Poll New Users to Excel 2 December 3rd 04 01:09 PM


All times are GMT +1. The time now is 07:23 AM.

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

About Us

"It's about Microsoft Excel"