Custom formatting

[John Knoke]

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

Thanks for any help

 

[Alan]

Right Click > Format Cells > Select Custom
Enter "........ "0.00

 

[Chip Pearson]

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



message
news:[email protected]...

 

[John Knoke]

Thanks Chip and Alan

Right Click > Format Cells > Select Custom
Enter "........ "0.00