+ Reply to Thread
Results 1 to 5 of 5

Cell Formatting

  1. #1
    Registered User
    Join Date
    02-07-2006
    Posts
    4

    Cell Formatting

    Hi,

    I am trying to have a specific format for a cell that i need some help with:

    the value of A3 = A1&" / "&A2 --> to give 3 / 3 for example - thats fine
    but the formatting of A1 and A2 are such that when 3 is entered it displays 3.0kg (due to 0.0"kg" as format)

    so now, how do i get the format of A3 to show 3.0kg / 3.0kg??

    Thanks

    Kyle

  2. #2
    Valued Forum Contributor mudraker's Avatar
    Join Date
    11-10-2003
    Location
    Melbourne, Australia
    Posts
    3,983
    This is one way
    = A1&"kg / "&A2&"kg"
    Please Read Forum Rules Before Posting
    Wrap VBA code by selecting the code and clicking the # icon or Read This
    How To Cross Post politely

    Top Excel links for beginners to Experts

    If you are pleased with a member's answer then use the Scales icon to rate it
    If my reply has assisted or failed to assist you I welcome your Feedback.

  3. #3
    Registered User
    Join Date
    02-07-2006
    Posts
    4
    that does work to some extent - thanks!

    but... i loose the '0's behind the decimal due to not having specific cell formatting.

    unless anyone else can come up with another solution...

  4. #4
    Forum Expert
    Join Date
    01-12-2007
    Location
    New Jersey
    Posts
    2,127
    Try this and report back:

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    02-07-2006
    Posts
    4
    legend! worked a treat. thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 15
    Last Post: 07-23-2008, 06:59 AM
  2. Conditional Formatting using a cell in another worksheet
    By mivital in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-16-2008, 01:52 PM
  3. individual formatting cell in a range
    By brianzs in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-15-2008, 12:13 PM
  4. Conditional formatting referencing another cell
    By tryer in forum Excel General
    Replies: 1
    Last Post: 06-16-2007, 03:26 AM
  5. Conditional Formatting based on 3 different cell values (criteria)
    By xlguy in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-05-2007, 05:36 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1