Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 190
Default why does blank space appear at end of number?

Sometimes a blank space appears at the end of a number in a cell.
Right-justify does not fix this. I tried deleting and re-entering, but
nothing seems to work. The other cells below and above are fully
right-justified, so one cell stands out. I've had this happen on numerous
occassions and don't know how to fix it.

Thanks,

Mary
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 258
Default why does blank space appear at end of number?

Mary --

It may be that you (or someone) clicked the indent or outdent button on that
cell. Have you tried copying the format from a cell above or below that
doesn't show the space?

"Mary" wrote:

Sometimes a blank space appears at the end of a number in a cell.
Right-justify does not fix this. I tried deleting and re-entering, but
nothing seems to work. The other cells below and above are fully
right-justified, so one cell stands out. I've had this happen on numerous
occassions and don't know how to fix it.

Thanks,

Mary

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,091
Default why does blank space appear at end of number?

Could be cell formatting. For example some cells are formatted in number
format, completely right justified and some in accounting format which
leaves a space at the right for a ")" in case of negative numbers. Make sure
your cell formatting is the same for all cells.

Tyro

"Mary" wrote in message
...
Sometimes a blank space appears at the end of a number in a cell.
Right-justify does not fix this. I tried deleting and re-entering, but
nothing seems to work. The other cells below and above are fully
right-justified, so one cell stands out. I've had this happen on numerous
occassions and don't know how to fix it.

Thanks,

Mary



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
How to remove blank space? Daniel Charts and Charting in Excel 1 August 6th 07 08:23 AM
add blank space in cell if first name is not blank stef Excel Worksheet Functions 6 August 23rd 06 02:26 AM
BLANK SPACE TO A NUMBER kevin Excel Worksheet Functions 3 December 30th 05 06:10 PM
I want a blank space on a worksheet when the question is blank? Patrizia Excel Discussion (Misc queries) 2 June 23rd 05 12:51 AM
Can I add blank space instead of 'FALSE' in VLookup? smithers2002 Excel Worksheet Functions 7 April 22nd 05 09:33 AM


All times are GMT +1. The time now is 11:44 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"