Input number to cell, but display as a relative percentage

[ajgcook83]

Good afternoon all,

I have a spreadsheet that will be distributed to external parties and then returned to me once populated.

In essence I'm asking the external parties to allocate time against their resources. This is done by inputting the number of days per month each resource will spend on the task in question.

I have already calculated the maximum available working days for each month and displayed these at the top of each column in the spreadsheet.

I would like the external parties to input a number of days utilisation into each cell, but have Excel to actually DISPLAY the % utilisation in the same cell.

A simple example (see attached sheet with cell in question highlighted yellow):
Maximum Working Days in Novemer: 20 (shown in G4)
Proposed Utilisation: 18 (this is the number the party would enter into the cell - in this instance G5)
Excel would therefore autocalculate and display 90% (in cell G5)

Can Excel do this automatically with a built-in function, or do i need to write a macro? I would like this to happen live; not have to click on a run-macro button.

I have seen it done before, but can't figure it out. Please help!

A.

[FDibbins]

I would like the external parties to input a number of days utilisation into each cell, but have Excel to actually DISPLAY the % utilisation in the same cell.

Can Excel do this automatically with a built-in function, or do i need to write a macro? I would like this to happen live; not have to click on a run-macro button.

A cell can either contain data (an entry) OR a formula, it cannot contain both - so yes, you would need VBA for that

Why not put the % in a cell next to the entry though, that way you still have teh raw data

[ajgcook83]

Thanks Ford!

I had a feeling that was the case.

A.

[FDibbins]

Glad to have cleared this up for you