How do I format a cell with numbers, text and hyphens
 

more details would help
e.g. i have ................... in my cells and i would like to see
......................

cheers
JulieD

"Yaya" wrote in message
...

If you want numbers, text, and hyphens, the cell must be formatted as TEXT.
But you won't be able to do any calculations with the numbers unless you
separate them out and use the value function.