LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
treybreak
 
Posts: n/a
Default Why isn't all the data in the cell displayed?

I'm entering text folowed by a series of periods
example Source Four Barrels 19°, 26°, 36°, 50°€¦€¦€¦€¦€¦€¦€¦...€¦€¦€¦€¦€¦€¦€¦ €¦
with the hopes that the information will be displayed with the cell just to
the right of it masking the last periods.
If I leave a space between the ° and the .... the ..... will disappear
depending on length if there is no space the 50°...................... all
disappear completly
I know this seems simple, but I'm entering the information into a
spreadsheet with at least 500 items, so I need this to be a simpler process.
I'm entering part description followed by ........ then the price cell to
the right
Any help would be much appreciated I could send anyone the file if needed.
Also the dots print with some periods larger than the rest and they appear
to be different sizes in the same cell after just holding down the period key
the fill the rest of the cell. Tried to search for answers, but didn't find
any.

Thanks,
Tom
 
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
resetting last cell jagdish.eashwar Excel Discussion (Misc queries) 11 March 31st 06 02:06 AM
Excel Macro to Copy & Paste [email protected] Excel Worksheet Functions 0 December 1st 05 01:56 PM
Printing data validation scenarios SJC Excel Worksheet Functions 14 July 24th 05 12:43 AM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


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