LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 10
Default Excel 07 - text displays as pound signs

OK, I'm not new to Excel, just 07. And this is killing me. I have a user who
uses Excel to track discussions of phone interviews, so she's using one cell
in which to type her comments. MOST of the time, the text is fine. Randomly,
any given cell will suddenly appear as all pound signs. Thes eare the things
I have tried and failed to prove consistent fixes:

1 - number of characters is irrelevant, happens on long and short text
2 - I make sure there is no hard return at end of text
3 - copy /past into plain text and bring back (sometimes works, sometimes not)
4 - changed font across entire tab sheet. nada
5 - remove empty space AND period at end of her typing. It worked once then
on today's two did nothing for me.

I have only seen this happen when text is exported from a SQL dbase and left
funky symbols in with the characters. But that was also importing into 03, so
this 07 newly typed in freak has me stumped.
 
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 does my text appear as pound signs Dr. Darrell Excel Discussion (Misc queries) 3 April 21st 23 09:05 PM
pound signs awh Excel Discussion (Misc queries) 3 June 28th 07 07:46 PM
Pound Signs...Yikes! AdinaC Excel Discussion (Misc queries) 4 December 6th 06 12:07 AM
Pound (#) signs instead of text mommyo Excel Discussion (Misc queries) 16 September 20th 05 01:45 AM
Why is my text changing to pound signs? SleepyDawn Excel Discussion (Misc queries) 2 February 9th 05 10:52 PM


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