New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus Advice and insight from world-class Apple enthusiasts Exclusive access to members-only contests, giveaways and deals

Join today!

 
Start a Discussion
 

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
OS X - Apps and Games Discussion of applications and games available for Mac OS X.

Formatting a cell as curency


Post Reply New Thread Subscribe

 
Thread Tools
hubblegc

 
Member Since: Dec 09, 2009
Location: Brazil
Posts: 10
hubblegc is on a distinguished road
Mac Specs: Macbook white, Core 2 Duo 2.26GHz, 2GB, 250GB

hubblegc is offline
Hi everybody!

Today when I was doing a sheet in Excel 2008 in my mac to control my personal wastes I had some problems on formatting a row as currency, for example when I typed $10,00 it shows $1.000,00... How can I fix it?

Tanks a lot!
QUOTE Thanks
toMACsh

 
toMACsh's Avatar
 
Member Since: Jul 30, 2009
Location: Wisconsin
Posts: 5,595
toMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to all
Mac Specs: Mac Mini Core 2 Duo

toMACsh is offline
Nice try with your English, but I'm sure you weren't trying to control your "personal wastes" with Excel. Whatever you were doing, the settings for number formatting can be found under the Format Menu. Choose Cells... and the Number tab.

I can't find how to switch the , and . in order to switch from the U.S. standard to replicate your entry. Sorry I can't give more specific direction.
QUOTE Thanks
hubblegc

 
Member Since: Dec 09, 2009
Location: Brazil
Posts: 10
hubblegc is on a distinguished road
Mac Specs: Macbook white, Core 2 Duo 2.26GHz, 2GB, 250GB

hubblegc is offline
Sorry about that. I guess to control my budget is the correct word. Anyway I could fix the problem with your directions.

Tanks a lot
QUOTE Thanks

Post Reply New Thread Subscribe


« Need solution to block pop under ads | iTunes 9: Listened-to Podcasts not transferring to iPod »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
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 On
Pingbacks are On
Refbacks are Off
Forum Jump

Similar Threads
Thread
Thread Starter
Forum
Replies
Last Post
Formulas in Numbers MissaRay OS X - Apps and Games 3 07-28-2009 07:13 PM
NeoOffice formatting question wanderluster OS X - Apps and Games 1 03-29-2007 09:47 PM

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

Powered by vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
X

Welcome to Mac-Forums.com

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!


(4 digit year)

Already a member?