Thanks Chip and Alan

"Alan" wrote:

Right Click Format Cells Select Custom
Enter "........ "0.00
"John Knoke" wrote in message
...

How can I do the following custom formatting -
I need trailing dots before the number
....1,234.00

Thanks for any help