Formatting a cell as curency

H

hubblegc


Joined
Dec 9, 2009
Messages
10
Reaction score
0
Points
1
Location
Brazil
Your Mac's Specs
Macbook white, Core 2 Duo 2.26GHz, 2GB, 250GB
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!
 
toMACsh

toMACsh


Joined
Jul 30, 2009
Messages
7,301
Reaction score
304
Points
83
Location
Wisconsin
Your Mac's Specs
Mac Mini (Late 2014) 2.6GHz Intel Core i5 Memory: 8GB 1600MHz DDR3
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.
 
OP
H

hubblegc


Joined
Dec 9, 2009
Messages
10
Reaction score
0
Points
1
Location
Brazil
Your Mac's Specs
Macbook white, Core 2 Duo 2.26GHz, 2GB, 250GB
:Oops: 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
 

Shop Amazon


Shop for your Apple, Mac, iPhone and other computer products on Amazon.
We are a participant in the Amazon Services LLC Associates Program, an affiliate program designed to provide a means for us to earn fees by linking to Amazon and affiliated sites.
Top