Custom number format

[Beneindias]

Hi everyone,

I can't ind anything about this and I'm not even sure if its possible.

I have a file with a lot of calculations.

In cell H7 I put a number
In cell I7 I have data validation, where I can choose between "Ton, M³ and Un".

Can I format cell H7 to have a custom number, where it shows what is chosen in I7?
For example, if in I7 I have selected Ton, I want to have H7 like "27 Ton", but if M³ is chosen, cell H7 should be "27 M³".

Is this possible??

Thanks for all the help

 

[awoohaw]

I think you would need VBA to do that to change the custom format of the cell.
But, if you wanted a 3rd cell you could concatenate the two (although it would then change the value to text).

 

[Beneindias]

I think you would need VBA to do that to change the custom format of the cell.
But, if you wanted a 3rd cell you could concatenate the two (although it would then change the value to text).

That's what I thought.
It's not worth it.

Thanks for your help

 

[Fluff]

You could use conditional formatting to change the cell format.

 

[awoohaw]

You could use conditional formatting to change the cell format.

i should have thought of that. thanks for that reminder @Fluff !

 

[Beneindias]

You could use conditional formatting to change the cell format.

Yeap, that worked.

Thank you all for the help.

 

[Fluff]

Glad we could help & thanks for the feedback.