+ Reply to Thread
Results 1 to 22 of 22

Cell with Number - Left align & overflow to adjacent cells

Hybrid View

  1. 06-24-2021, 04:58 AM #1
    Rick Rothstein
    Rick Rothstein is offline
    Forum Guru
    Join Date
    04-23-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 365
    Posts
    2,463

    Re: Cell with Number - Left align & overflow to adjacent cells

    Quote Originally Posted by Un-Do Re-Do View Post
    Is this possible at all?
    To left align a cell with a number. and have it overflow to the next cell/s.
    Let's say your formula is this...

    =A3/B3

    simply change the formula to this...

    =TEXT(A3/B3,"General")

    You should be able to do something similar with whatever your actual formula is.
    Last edited by Rick Rothstein; 06-24-2021 at 05:04 AM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to get cell overflow to the left when adjacent cell has value in it?
    By greaseebogus in forum Excel General
    Replies: 2
    Last Post: 09-19-2017, 08:05 AM
  2. VBA excel to word insert footer (Text - Left align) & (Page number - Right align)
    By Richavlaues in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-23-2017, 06:22 PM
  3. Align Left and Right in Same Cell
    By snapfade in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-25-2014, 04:08 PM
  4. [SOLVED] Date Field Overflow Into Adjacent Cell
    By CrocHntr in forum Excel General
    Replies: 3
    Last Post: 03-20-2014, 01:36 PM
  5. Combobox Left Align Text that's too long to fit into cell
    By tigerlilly4321 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-08-2013, 12:08 AM
  6. Left align '$' and right align numbers?
    By skeetley in forum Excel General
    Replies: 1
    Last Post: 10-21-2005, 03:12 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1