Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Custom formatting
How can I do the following custom formatting €“ I need trailing dots before the number €¦€¦..1,234.00 Thanks for any help |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
custom cell formatting | Excel Discussion (Misc queries) | |||
custom formatting | Setting up and Configuration of Excel | |||
Custom Formatting a number | Excel Discussion (Misc queries) | |||
Custom Number formatting | Excel Worksheet Functions | |||
Custom formatting | Excel Discussion (Misc queries) |