LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 3rd 18, 02:36 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
First recorded activity by ExcelBanter: Jun 2018
Posts: 5
Default Hwo can a calculation change the alignment/justification?

I work in Excel 2016, and have expericenced a strange phenomenon, but apprarently only in one spreasdheet.

In one cell (A123) I have a number, like 500. In another cell (L122) I have a formula, =SUM(K122;H122:J122). In a third cell (B123) I like to subtract the result of the formula from the number, like =A123-L122. The result is correct, but the content of B123 is left justified in stead of being right justified. When I look at the format, it is set to Standard and so are A123 and L122. And even if I try to right justify B123, the format says Right justified, the but number remains to the left in the cell.

If I try in another sheet it works fine.

Any ideas?


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
Change Alignment Defaults Victoria Excel Worksheet Functions 4 February 24th 09 04:09 PM
Change justification in right Excel header box to left justify. sdiederick Excel Discussion (Misc queries) 0 May 9th 06 10:16 PM
How do you change the default alignment of merged cells? Jim J. Excel Programming 1 April 18th 06 07:59 PM
How to change Alignment of cells to middle Grd New Users to Excel 1 February 8th 06 04:34 PM
can't change the alignment of numbers in cells create_share Excel Discussion (Misc queries) 5 December 13th 05 08:36 PM

All times are GMT +1. The time now is 12:59 AM.

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

About Us

"It's about Microsoft Excel"


Copyright © 2017