Numbers to text in specific format

[losty]

Hi there:

If in a table I have three columns with numbers such as:

A B C
1 898 90909

what formula can I use to convert them to text such that the output looks like: 1:898-90909 (as I said I want it in this format in text).

Thanks in advance!

[Marcol]

Maybe

Please Login or Register  to view this content.

[AndyPS]

You might like to try

Please Login or Register  to view this content.

This should work for numbers that start in 0.

[losty]

Marcol,

Thanks so much. Working from that the correct code was:

Please Login or Register  to view this content.

Again thank you!

[Marcol]

Why put &"" at the end of the formula?