Menu

Format Cells - Architectural Dimensions

Search this Thread

Prev

Previous Post

Next Post

Next

#4

Report Post

Posted to microsoft.public.excel.misc

paul

paul is offline

external usenet poster

Posts: 247

Default

Format Cells - Architectural Dimensions

you still watching kleivakat?
--
paul

remove nospam for email addy!

"kleivakat" wrote:

I'm gathering the information from my students on various critical dimensions
(interior design class). They've taken a variety of field measures, and I'm
putting the information into a spreadsheet so that we can see numbers highest
to lowest, average distance, etc. I'm entering the data myself from their
worksheets, so there are about 20 sheets with 25 dimensions each. Once I
have that data, I want to be able to sort, average, etc., but I'm not doing
anything any more sophisticated than that.

"paul" wrote:

yes,i am sure it can be done,but the completeness of the solution will depend
upon how you want to use the resulting numbers.What do you mean by "sort and
average".what happens to the data afterwards,how is the data input or
imported.
--
paul

remove nospam for email addy!

"kleivakat" wrote:

Can I format cells to use architectural dimensions so that I can sort and
average dimensions? I need to be able to enter and work with numbers that
look like:

2'-6"
3'-8"

I'd rather not convert to inches if I don't have to. If I did that, I would
want a macro to figure out the math (i.e., 3'-8" - 44") since I have a lot of
data to deal with. Also, the nubmers are given to me in dimensions, and I
don't want to convert in my head as I enter data.

Thanks for any info.

KK

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calculating only non-empty cells...	Jay	Excel Worksheet Functions	9	September 22nd 06 03:20 AM
Why will my cells not format?	Jamie Kelly	New Users to Excel	3	January 13th 06 06:41 PM
Number format exactly the same, displays differently in some cells	eider	Excel Discussion (Misc queries)	1	July 29th 05 12:26 AM
format cells dialog box does not come up	GMed	Excel Discussion (Misc queries)	1	April 14th 05 05:00 PM
Protected cells -automatically format to a different color	Fred Evans	Excel Discussion (Misc queries)	9	December 3rd 04 12:59 PM

All times are GMT +1. The time now is 05:16 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement