Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-02-2014, 02:42 PM
MS baby MS baby is offline Formatting numbers in number column Windows 7 64bit Formatting numbers in number column Office 2013
Novice
Formatting numbers in number column
 
Join Date: Feb 2014
Posts: 11
MS baby is on a distinguished road
Default Formatting numbers in number column

Hello,


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

THNX
Reply With Quote
  #2  
Old 06-03-2014, 02:43 PM
JulieS JulieS is offline Formatting numbers in number column Windows 7 64bit Formatting numbers in number column Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

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")
Reply With Quote
Reply

Thread Tools
Display Modes


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
Formatting numbers in number column 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
Formatting numbers in number column Last Number in a Column paulrm906 Excel 1 12-05-2008 07:51 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:02 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft