View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
bj bj is offline
external usenet poster
 
Posts: 1,397
Default how to format existing entry on a cell

use<format<cell<number<custom (000) 000-0000
i will be a number but look like what you have (i assume you want the space
afetr the parenthsis).

"Maverick" wrote:

I have an existing entry that (760) 725-5740 and I want to be type in as
7607255740 with deleting my existing entry and it will still show as (760)
725-5740.