Formatting a cell to display a space at mid point of value

Hi All,

The formula is OK - but I'm not sure if I can get it operate on the cell the data is entered in.

C2 = 123456, I want it to display as 123 456.

The data will be different lengths - but all lengths will be even numbers

So formula is:

=LEFT(C2,(LEN(C2)/2)) &" "& RIGHT(C2,(LEN(C2)/2))

I wan the result displayed in the same cell the data is entered into - in this case C2.

So - essentially - can conditional formatting do this - I've had a play and can't make it work.

Thanks

Mark

thx - sorry - might be dumb Q - but how do I test for length?

the other thing I wish to do is conditionally format decimal places

eg

if C1=miles

then C4 formatted to 2 decimal places

again - want this done in the data entry field

thanks

thanks -

I'm not sure what CF is and where to use the LEN function.

Originally Posted by mbender

thanks -

I'm not sure what CF is and where to use the LEN function.

The problem I'm having in thinking through a solution is that you want the results to appear in the same sell you type into. Conditional formating works base on a true/false outcome. The formula you proposed does not produce a true/false result. If you try to manually type the number into the the cell and you have a formula there you obviously write over the formula. If you know how many possible lengths you might have you could come up with one conditional formatting for each size. so if the length= 4 apply this formatting, if the length=6 apply this formatting, etc.

I wish I could help you a little more but but if you are hard set on the input cell being the same cell as the formatted cell your options are somewhat limited.