ExcelBanter - adding text that appears after the entered data

ExcelBanter (https://www.excelbanter.com/)

- Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)

- - adding text that appears after the entered data (https://www.excelbanter.com/setting-up-configuration-excel/186150-adding-text-appears-after-entered-data.html)

Cindy B

adding text that appears after the entered data

How do I insert text in a field - but just have the user enter the number?
example..
I want the field to be 5 years, but I only the the user to enter the number 5.
I've seen this done in Excel - but can not figure out how to do it.

thanks for any help you can send my way!
--
Cindy B

Gord Dibben

adding text that appears after the entered data

FormatCellsNumberCustom 0" Years"

Gord Dibben MS Excel MVP

On Sun, 4 May 2008 18:53:00 -0700, Cindy B wrote:

How do I insert text in a field - but just have the user enter the number?
example..
I want the field to be 5 years, but I only the the user to enter the number 5.
I've seen this done in Excel - but can not figure out how to do it.

thanks for any help you can send my way!

Cindy B

adding text that appears after the entered data

thank you so much!!!!!
--
Cindy B

"Gord Dibben" wrote:

FormatCellsNumberCustom 0" Years"

Gord Dibben MS Excel MVP

On Sun, 4 May 2008 18:53:00 -0700, Cindy B wrote:

How do I insert text in a field - but just have the user enter the number?
example..
I want the field to be 5 years, but I only the the user to enter the number 5.
I've seen this done in Excel - but can not figure out how to do it.

thanks for any help you can send my way!

All times are GMT +1. The time now is 06:19 PM.