Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Referencing a value over 255 characters within a table PLUS strange formula behaviour
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 01-08-2013, 09:36 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Referencing a value over 255 characters within a table PLUS strange formula behaviour Windows 7 32bit Referencing a value over 255 characters within a table PLUS strange formula behaviour Office 2010 32bit
Expert
  
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

Hi,

I haven't looked at your sample sheet but I am quite sure that both the behaviours you describe are because the table cells are formatted as Text. To remediate, select the entire problematic column, press CTRL+1 to open the Format cells dialog, choose General and click OK. That should fix it.
Reply With Quote
  #2  
Old 01-08-2013, 09:39 AM
TishyMouse TishyMouse is offline Referencing a value over 255 characters within a table PLUS strange formula behaviour Windows XP Referencing a value over 255 characters within a table PLUS strange formula behaviour Office 2007
Novice
Referencing a value over 255 characters within a table PLUS strange formula behaviour 		 
Join Date: Feb 2012
Posts: 22
TishyMouse is on a distinguished road
Thumbs up
Hurrah, that works a treat. Thanks!
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Referencing a value over 255 characters within a table PLUS strange formula behaviour Word VBA: Cannot Edit Range (Delete characters except the first in a table cell) tinfanide Word VBA 3 04-27-2012 09:48 AM
Referencing a value over 255 characters within a table PLUS strange formula behaviour Referencing something that isn't numbered (eg table, figure etc) hanvyj Word 2 04-10-2012 03:30 AM
Referencing a value over 255 characters within a table PLUS strange formula behaviour Odd behaviour of table - keep rows together Stephan Lindner Word Tables 1 09-10-2011 05:31 AM
Junk characters (box-like characters) in Word file Sashikala Word 1 04-20-2010 02:03 PM
Referencing a value over 255 characters within a table PLUS strange formula behaviour Formula and Table Help! steveman1234 Word Tables 2 03-28-2010 06:20 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:39 PM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft