Transfer one digit to one cell in Excel

I'm trying to transfer one digit of a number into one cell from one workbook to another.

Example: Worksheet 1: 1,234.56 Worksheet 2: A1 A2 A3 A4 A5 A6 1 2 3 4 5 6

These are the formulas I've been using but the last formula for the last digit isn't correct.

A1 Formula: This works =IF('Worksheet 1'!D7>9999999.99,MID('Worksheet 1'!D7,7,1),IF('Worksheet 1'!D7>999999.99,MID('Worksheet 1'!D7,6,1),IF('Worksheet 1'!D7>99999.99,MID('Worksheet 1'!D7,5,1),IF('Worksheet 1'!D7>9999.99,MID('Worksheet 1'!D7,4,1),IF('Worksheet 1'!D7>999.99,MID('Worksheet 1'!D7,3,1),IF('Worksheet 1'!D7>99.99,MID('Worksheet 1'!D7,2,1),IF('Worksheet 1'!D7>9.99,MID('Worksheet 1'!D7,1,1),"")))))))

A6 cell: This does not work: =IF(MID(RIGHT('Worksheet 1'!D7,2),1,1)=".",MID(RIGHT('Worksheet 1'!D7,2),1,1),IF(MID(RIGHT('Worksheet 1'!D7,2),1,2)=".",RIGHT('Worksheet 1'!D7,1),"0"))

Recent Questions...