help with numbers - need currency field with , - ehMac.ca
Facebook
Twitter
YouTube
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read Advertise


Reply
 
LinkBack Thread Tools Display Modes
Old Mar 9th, 2019, 04:55 PM   #1
Full Citizen
 
Join Date: Oct 2006
Posts: 823
help with numbers - need currency field with ,

Hi All,

Im using numbers to do some calculations. I formatted the cell to provide the $ symbol.
However, I would like to have a , once I pass 4 digits

$1,000 or $10,500 currently numbers shows the values without a comma $1000 or $10500

I find it easier on the eye with a comma.

Anyone know how to do that?

I'm using Numbers 3.6.1

Thanks
macmac is offline   Reply With Quote
Sponsored Links
Advertisement
 
Old Mar 9th, 2019, 05:01 PM   #2
Honourable Citizen
 
Join Date: Nov 2006
Posts: 17,180
Fairly easy; Right corner of the top icon bar click on the Format button, select cell, select currency under data select, check the thousands separator box.
__________________
Ad links appearing in my posts were not placed there by me. I do not endorse any products which may be linked to my posts. Do not click on those links.

I retain all rights to photo-images I have posted on ehMac. They were posted that other members of the community could enjoy them. They may not be used or sold in any other way without my written consent.

Bill C-51 is an act of Terrorism! It cannot be fixed and should be immediately repealed!
eMacMan is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom number formatting in Numbers tilt Mac, iPhone, iPad and iPod Help & Troubleshooting 16 Apr 22nd, 2014 08:11 PM
Numbers, entering today's date Morley Mac, iPhone, iPad and iPod Help & Troubleshooting 3 Sep 6th, 2013 07:49 AM
Numbers spreadsheet Widget? thedave Anything Mac 0 Feb 26th, 2009 10:47 AM
Should North America (NA) change to a NA currency? Urban_Legend Everything Else, eh! 22 Aug 7th, 2003 01:28 PM


All times are GMT -4. The time now is 02:39 PM.



Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
vBulletin Security provided by vBSecurity v2.2.2 (Pro) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
Copyright 1999 - 2012, ehMac.ca All rights reserved. ehMac is not affiliated with Apple Inc. Mac, iPod, iTunes, iPhone, Apple TV are trademarks of Apple Inc. Content Relevant URLs by vBSEO 3.6.0 RC 2

Tribe.ca: Urban living in Toronto!