Results 1 to 4 of 4

custom format help (leading decimal pt and Inch mark)

Threaded View

chesspupil custom format help (leading... 07-06-2011, 08:11 PM
MarvinP Re: custom format help... 07-06-2011, 09:16 PM
Palmetto Re: custom format help... 07-06-2011, 09:29 PM
chesspupil Re: custom format help... 07-06-2011, 10:04 PM
  1. #1
    Registered User
    Join Date
    05-21-2006
    Posts
    21

    custom format help (leading decimal pt and Inch mark)

    Using Excel 2007
    I am trying to enter thousands of thickensss readings that were recorded manually and must be transcribed over to excel/

    I have numbers like 432 433 435 431 444 Each value in its own cell

    Would like the result

    0.432" 0.433" 0.435" 0.431" 0.444

    I would like to do this where I only enter the digits and the format results in the same cell rather than a formula target to a new result cell

    I imagined this might work for the first set of number, but no [$ 0.]#0[$ "]
    --------------------------------
    Not in the same report I have a similar problem:

    I also have some data that is 132 133 135 136 130

    Would like to have result:

    1.32" 1.33" 1.35" 1.36" 1.30"

    Thank you for your time

    Cross post
    http://www.mrexcel.com/forum/showthread.php?p=2779610#post2779610
    Last edited by chesspupil; 07-06-2011 at 08:19 PM.

Thread Information

Users Browsing this Thread

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

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