Good morning Mr. Excel Community,
I need help to create a custom cell value format to show my input (4 digit number) as "##'-##" (Ft'-In"). I've done some research on the rules/boundaries for creating custom cell formats within Excel & how to add text to a numerical value, but I have not been able to successfully add text (such as ##"'-"##""") in 2 separate locations within my cell value.
My goal is for this custom cell format to work similarly to the dimensions fields within Onscreen Take-off (OSTO), the primary software I use in my current position. Within OSTO, the dimensions are entered as 4 digits (first 2 digits as FEET, last 2 digits as inches) and the punctuation is added to create a dimensional output. For example...
0106 = 1'-6"
1109 = 11'-9"
2403 = 24'-3"
0610 = 6'-10"
Can this be achieved via a custom cell format? Or would it be necessary to have multiple columns (such as FEET & INCHES) with a 3rd column to concatenate the values with the desired punctuation/in the desired format?
Thanks in advance for any light you can shed on this.
I need help to create a custom cell value format to show my input (4 digit number) as "##'-##" (Ft'-In"). I've done some research on the rules/boundaries for creating custom cell formats within Excel & how to add text to a numerical value, but I have not been able to successfully add text (such as ##"'-"##""") in 2 separate locations within my cell value.
My goal is for this custom cell format to work similarly to the dimensions fields within Onscreen Take-off (OSTO), the primary software I use in my current position. Within OSTO, the dimensions are entered as 4 digits (first 2 digits as FEET, last 2 digits as inches) and the punctuation is added to create a dimensional output. For example...
0106 = 1'-6"
1109 = 11'-9"
2403 = 24'-3"
0610 = 6'-10"
Can this be achieved via a custom cell format? Or would it be necessary to have multiple columns (such as FEET & INCHES) with a 3rd column to concatenate the values with the desired punctuation/in the desired format?
Thanks in advance for any light you can shed on this.