Custom formating text in format settings

[chaosincarnate]

Morning/Evening/Afternoon,


Hopefully this is a simple solution.


I have cells that I have a custon format in (+0;-0). What I want to do is add commas to it also so that when the the number shows up in it, it will place the comma's in the appropriate spots for 1,000's, 1,000,000's, etc.


Sometimes the cell may have a word in it (I think 2 of the 5 cells do) when there is no information to display..

 

[mrzoogle]

Hi chaosincarnate,


I think you can just format the cell as Number and tick "use 1000 separator". This should give you the result you looking for.


Regards,


Z.

 

[NARAYANK991]

Hi ,


Change your existing format slightly to :


+#,##0;-#,##0


Narayan

 

[Guest]

Such a delay would certainly someone because of mental tension crash,murray

 

[chaosincarnate]

Thanks for the help.


Worked perfectly.