format cell

  • Thread starter Thread starter crapit
  • Start date Start date
C

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
 
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
Click to expand...
 
Close Dave, but the formula is:

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

Good Luck :)



Dave Peterson said:
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
Click to expand...
Click to expand...
 
ND Pard

Re-read the original post.


Gord Dibben MS Excel MVP


Close Dave, but the formula is:

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

Good Luck :)



Dave Peterson said:
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
Click to expand...
Click to expand...
Click to expand...
 
How about automatically create space before and after a separator sign?

I.e key in 3/4, appear as 3 / 4
 
See if this works for you.

Format > Cells > Custom
# / #

HTH
Regards,
Howard

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

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

crapit said:
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
Click to expand...
Click to expand...
 
Back
Top