#1   Report Post  
Posted to microsoft.public.excel.misc
Billy
 
Posts: n/a
Default All x's in cell

Cell is set up to enter a fax #.Only x's appear when the numbers are entered.
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student
 
Posts: n/a
Default All x's in cell

When entering the information, precede the number with a single quote
(apostrophe)
--
Gary's Student


"Billy" wrote:

Cell is set up to enter a fax #.Only x's appear when the numbers are entered.

  #3   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten
 
Posts: n/a
Default All x's in cell

<Cell is set up to enter a fax #.

How did you do that?

<Only x's appear

Or #'s?

--
Kind regards,

Niek Otten

"Billy" wrote in message
...
Cell is set up to enter a fax #.Only x's appear when the numbers are
entered.



  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default All x's in cell

If they're really #'s, then widen the column or use a smaller font. (or enter
it as text following Gary's Student's suggestion.)

Billy wrote:

Cell is set up to enter a fax #.Only x's appear when the numbers are entered.


--

Dave Peterson
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
Adding a row to worksheet does not update cell references in another. blausen Excel Worksheet Functions 5 February 25th 06 09:14 PM
Instead of a negative number, I'd like to show zero... Dr. Darrell Excel Worksheet Functions 6 December 7th 05 08:21 PM
Cell color based upon cell value My View Excel Discussion (Misc queries) 11 July 6th 05 03:59 AM
cell color index comparison MINAL ZUNKE New Users to Excel 1 June 30th 05 07:11 AM
Function syntax to compare cell contents ES Excel Worksheet Functions 2 May 18th 05 03:53 PM


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