ExcelBanter - Formula

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Formula (https://www.excelbanter.com/excel-worksheet-functions/128310-formula.html)

Matt_07

Formula

Im wanting to make it so TC07 comes up and and then the user can add 4 digits
to the end

For example tc07 4345

The 4345 would be imput but the user but the tco7 would already be there any
help
cheers

-- OMatt

Gary''s Student

Formula

Format Cells... Number Custom
"TC07"General
--
Gary''s Student
gsnu200703

"Matt_07" wrote:

Im wanting to make it so TC07 comes up and and then the user can add 4 digits
to the end

For example tc07 4345

The 4345 would be imput but the user but the tco7 would already be there any
help
cheers

-- OMatt

All times are GMT +1. The time now is 03:29 AM.