View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
scott scott is offline
external usenet poster
 
Posts: 577
Default How do I format the number -123456789 as -12,34,56,789?

Hi Hector

Thank You.

The solution offered does not work for negative numbers. Can you please help?

Scott

"Héctor Miguel" wrote:

hi, Scott !

try with the following custom number format:
[9999999]##\,##\,##\,##0;[99999]##\,##\,##0;#,##0

hth,
hector.