format cell

[crapit]

How to set a cell so that when I key in [number] follow by [/] follow by
[number] and display as number - number

I.e key in 3/4, appear as 3 - 4

 

[Dave Peterson]

Not by formatting alone.

You could format the cell as text (not general, not a date)
and use the adjacent cell to return the string the way you want to see it:

=substitute(a1,"/"," - ")

After you do all your data entry, you could hide the original column or even
convert the formula column to values and delete the original column.

How to set a cell so that when I key in [number] follow by [/] follow by
[number] and display as number - number

I.e key in 3/4, appear as 3 - 4

 

[ND Pard]

Close Dave, but the formula is:

=substitute(A1,"-","/")

Good Luck

Not by formatting alone.

You could format the cell as text (not general, not a date)
and use the adjacent cell to return the string the way you want to see it:

=substitute(a1,"/"," - ")

After you do all your data entry, you could hide the original column or even
convert the formula column to values and delete the original column.

How to set a cell so that when I key in [number] follow by [/] follow by
[number] and display as number - number

I.e key in 3/4, appear as 3 - 4

 

[Gord Dibben]

ND Pard

Re-read the original post.


Gord Dibben MS Excel MVP

Close Dave, but the formula is:

=substitute(A1,"-","/")

Good Luck

Not by formatting alone.

You could format the cell as text (not general, not a date)
and use the adjacent cell to return the string the way you want to see it:

=substitute(a1,"/"," - ")

After you do all your data entry, you could hide the original column or even
convert the formula column to values and delete the original column.

How to set a cell so that when I key in [number] follow by [/] follow by
[number] and display as number - number

I.e key in 3/4, appear as 3 - 4

 

[crapit]

How about automatically create space before and after a separator sign?

I.e key in 3/4, appear as 3 / 4

 

[L. Howard Kittle]

See if this works for you.

Format > Cells > Custom
# / #

HTH
Regards,
Howard

How about automatically create space before and after a separator sign?

I.e key in 3/4, appear as 3 / 4

How to set a cell so that when I key in [number] follow by [/] follow by
[number] and display as number - number

I.e key in 3/4, appear as 3 - 4