ExcelBanter - formatting

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - formatting (https://www.excelbanter.com/excel-discussion-misc-queries/75546-formatting.html)

nick

formatting

Hi,

In worksheet 1 i have 3 fields:
A1 A2 A3
1234 1 19980101

A2 is a 3 character field, some with leading zeros and some without. A3 is
the date but i need to populate it as YYDDD. I need to populate all 3 fields
together in the following format:

12340019001
How do i do this? ANy help? Thanks

nick

formatting

Sorry in the format, 8 is missing...the correct format shld be 123400198001

"nick" wrote:

Hi,

In worksheet 1 i have 3 fields:
A1 A2 A3
1234 1 19980101

A2 is a 3 character field, some with leading zeros and some without. A3 is
the date but i need to populate it as YYDDD. I need to populate all 3 fields
together in the following format:

12340019001
How do i do this? ANy help? Thanks

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