ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Label/data hidden (https://www.excelbanter.com/new-users-excel/12764-label-data-hidden.html)

Karsten Pedersen

Label/data hidden
 
I need to know if there is any way that I can program cells so that
they will display a name (such as 'Group 14'), but 'underneath' the
name there's a number that can be used in a row so that it can be one
of the elements in e.g a sum.

I hope that you see what I mean

Karsten Pedersen

Peo Sjoblom

Use a custom format

"Group 14"


--

Regards,

Peo Sjoblom


"Karsten Pedersen" wrote in message
om...
I need to know if there is any way that I can program cells so that
they will display a name (such as 'Group 14'), but 'underneath' the
name there's a number that can be used in a row so that it can be one
of the elements in e.g a sum.

I hope that you see what I mean

Karsten Pedersen





All times are GMT +1. The time now is 08:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com