I'm working on a spreadsheet and the first column is numbers that are Police
Case Files. These numbers should be year and 4 digit number (08-0585). The
numbers (text) after the date 08 have been entered incorrectly without the -
0. Is there a
formula I could use to change all the case files to add the -0.

hi
try this....
=LEFT(B2,2)&"-"&RIGHT(B2,4)

coverts 080585(your example) to 08-0585

adjust cell reference to fit your data.

regards
FSt1

"JWR55" wrote:

I'm working on a spreadsheet and the first column is numbers that are Police
Case Files. These numbers should be year and 4 digit number (08-0585). The
numbers (text) after the date 08 have been entered incorrectly without the -
0. Is there a
formula I could use to change all the case files to add the -0.

On Feb 21, 1:46*pm, FSt1 wrote:
hi
try this....
=LEFT(B2,2)&"-"&RIGHT(B2,4)

coverts 080585(your example) to 08-0585

adjust cell reference to fit your data.

regards
FSt1



"JWR55" wrote:
I'm working on a spreadsheet and the first column is numbers that are Police
Case Files. These numbers should be year and 4 digit number (08-0585). *The
numbers (text) after the date 08 have been entered incorrectly without the -
0. *Is there a
formula I could use to change all the case files to add the -0.- Hide quoted text -

- Show quoted text -

Was thinking this might better answer the question:
=LEFT(A2,2)&"-0"&RIGHT(A2,3)