Custom formatting
 

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

Thanks for any help

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

John,

Use a custom number format of *.#,###.00

Note the period between the * and the first #.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"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

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