Sorry guys for the trouble. I have been trying and trying to wrap my head around doing this and looked for some time now with nothing figured out. What I'm needing to do is I have a cell that has a 3 digit number in it, sometimes it will have a 0 as the first number. I need to take that three digit number and split it into three cells and keep the 0 in the first cell. Like if I have 097 in A1, I would need 0 in B1, 9 in C1 and 7 in D1. I need them to stay as numeric value so my formulas from another sheet will pick them up.

I know this is something simple and I thought I had a formula for this on one of my discs, but I can not find it after a fresh reinstall.

Thank you all so much!!!