1/4

Hi All, I'm working on a tool that will help me manage project planning for my team. I have a basic sheet that looks something like this: <tbody> Task Time Allowed (in hours) Assigned to Start Date End Date # of Days 1/1 1/2 1/3 1/4 1/5 A 2 John 1/1 1/2 2 1 1 0 0 0 B 5 Sally 1/2 1/5 4 0...

Excel 2003 I receive PDF drawings that are drawn to scale, but are printed as such that scaling gets screwed up. Looking for a formula to go into cell B9 ... that will reference cell I9, and return 1/4". ... and when "Dimension from plan" is changed to 65 0 0 ( I9 will now be 5.33 ) B9...

Why is Excel changing my date to a fraction? Exp: I enter 1/4, it gives me 1/4 instead of Apr-2019; it ignores the date format I chose, MMM-YYYY

Using excel 2010 I have the following line of code. Range("D13") = "(6) 1 1/4" Screws" I want range D13 to say the following: (6) 1 1/4" Screws I want the single quotation mark after 1 1/4 to be displayed since it's denoting inches. But I keep getting a debug. What do I need to add to...

Hello, thanks for checking this out. I am trying to get the percent in a cell from columns L through Q. The % is dependent on the FY in L1:Q1 and the % is also dependent on the names in column E, R, and G The names in column E and F are copied to R1 & S1. The FY are contained in L1:Q1. The...

I am trying to size my rows and columns by inches, instead of pixels and cannot get it to work. I went to Options>Advanced>Display and changed the default to inches. When I type in these options I get an error message....1/4, 1/4 in, .25 in. Error message - Your entry cannot be used. Am...