Cell formatting for number and text display

**breadwinner** · 06-25-2013, 02:24 AM

Dear Experts

I WANT MAKE THE CELL DISPLAY AS (NUMBERIC) "1" IF I ENTER NUMBERS {WEEK} SHOULD DISPLAY "WEEK 1 "BUT CELL VALUE SHOULD BE "1".
ANOTHER I WANT MAKE THE CELL DISPLAY (DATES.xlsTEXT)"A" IF I ENTER {ZONE } SHOULD DISPLAY "ZONE A" BUT CELL VALUE SHOULD BE "A"

please find the attachment

thanks to all

**corinereyes** · 06-25-2013, 02:55 AM

Hi,

Try this.

Please check the attached file.

Formula used:

Please Login or Register  to view this content.

changing the position of the soure data.

**humdingaling** · 06-25-2013, 03:05 AM

Zone/Tier

Please Login or Register  to view this content.

the week number needs extra trim and value

Please Login or Register  to view this content.

Trim because you need 2 Characters in case of week 10
value because right formula terms to text

**breadwinner** · 06-25-2013, 03:44 AM

Main requirement is i want display values nos 1 or 2 or 3 even though text is entered in cell display nos In case

i think some cell formation with "WEEK-1";0;"";" "& IF I ENTER 2 THEN IT SHOULD CHANGE WEEK-2