Formatting numbers in number column

MS baby · #1 06-02-2014, 02:42 PM

Hello,
Can You please explain: how to format numbers in number column to get thousand separator and two decimals?

THNX

JulieS · #2 06-03-2014, 02:43 PM

I don't believe the number field can be formatted. You can format the value i the custom field in a text field. For example: the number entry is in Number1 and the formula below is in Text1:

Format([Number1],"#,##0.00")

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to change the formatting of numbers without changing the numbers?	sullengirl	Word	2	01-27-2014 03:06 PM
Spliting column with text and numbers	mjosic	Excel	3	04-04-2012 05:56 AM
Different column numbers, but same place on page -- what is going on?! Help	Straitsfan	Word	3	03-01-2012 03:05 PM
Can I auto increase numbers in a column?	compact	Word	1	09-10-2009 07:16 AM
Last Number in a Column	paulrm906	Excel	1	12-05-2008 07:51 PM