LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
D_Mac
 
Posts: n/a
Default Problem with multiple # in cell - help please

I am creating data spreadsheets in this program. In some cells, the
information shows up as #####, while in others it shows up fine. Is there a
way to get rid of the ####s? The content is text and numeric, though, and the
batch loader the files are loaded into don't recognize the ####.

I just went and looked at the data in the cells where the multiple #s are
showing

up. Sometimes it's body text (sentences, text, that kind of thing) with no
numbers. Sometimes there are numbers in with the body text. But it doesn't
seem to be consistent when the #s appear in the cells.

Thanks again. I hope you guys can help.
 
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
Problem Referencing Multiple Lists Neil M Excel Worksheet Functions 3 December 9th 05 05:01 PM
spinner linked cell problem jim Excel Discussion (Misc queries) 2 July 22nd 05 04:08 PM
Multiple Employee Name Entries in One Cell Dave Excel Discussion (Misc queries) 1 June 17th 05 03:33 AM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM
Problem with IF condition or vector lookup? J-Philippe Excel Worksheet Functions 4 January 15th 05 08:41 PM


All times are GMT +1. The time now is 12:24 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"