I can't put numbers on the decimals. It only allow ,00 as decimals. If i put 33.00 it's ok but i i put 33.44 when i press enter changes to 3344 as an entire number, i've try everything and can't find the solution. This should be a basic thing.

pedrofromsydney wrote:

€ 55,555.00

that's the result i get. Still why can't i just type for ex. 29.55 and stay like that on the cell ? Why does it always change to 2955 or 2955.00. ??

I don't understand this

It appears you have the cell formatted to Currency, with the default two decimal places.

What I don't understand, though is how Numbers arrived at a result of fifty five thousand five hundred fifty five on your entering the exact keystrokes in Yvan's post:

an equals sign, followed by five ones, followed by a forward slash, followed by a 2.

Here's the result I get:

Could you do the following:

• Open a NEW Numbers document using the Blank template.
• Drag the Row and Column control (bottom right corner) to reduce the table to two columns and three rows.
• Enter the words "My table" in cell A1.
• Click on cell B2 to select it, then enter the formula
  =11111/5
  Use only those eight keystrokes; do not include any commas, periods or other characters not shown.
• Click on B2 again to select it.
• Open the inspector and choose the Cell Format button.
• Do not make any changes in the Inspector window.
• Drag the Inspector window to the position shown in my screen shot.
• Take a screen shot that includes the Formula bar, the Table (with cell B2 selected) and the Cell Format Inspector pane (the same screen area as in my screen shot above).
• Post the screen shot in a reply to this post.

I'm hoping there will be some clues as to what's happening here in the screen shot. Procedure for taking and posting a shot of part of the screen follows.

Regards,

Barry

SCREEN SHOTS (Selected area)

1. Place the mouse pointer at the top left corner of the area you want to include.
2. Press shift-command-4.
3. The mouse pointer will change to a plus sign on a circle.
4. Hold down the mouse button and drag to the bottom right corner of the area you wan to capture.
5. Release the mouse button.

The screen shot will be saved to your desktop with the name "Picture 1" (The number will be different if you have taken other screen shots).

POSTING

1. In the Compose frame, place the Insertion point at the location you want the picture to be inserted.
2. Click the camera icon above the compose frame to open the Insert Image dialogue.
3. Click Choose file to open the Choose dialogue.
4. If necessary, navigate to the Desktop and click on the 'by date column header to sort the files by date, most recent at the top.
5. Select the most recent picture file.
6. Click Choose.
7. Wait for the picture's file name to appear beside Choose file.
8. Click insert image.
9. Done.

B.

Change the format to text and you can type whatever you want. If it is formatted as automatic or number and you type something that is numeric-like, it might fix the typo for you and use it as a number or it might treat it as text. From what you said in your last post, you use the comma as the decimal separator. In that case, "33.44" is not a number but "33,40" is. If you want it to stay as 33.40 then you either have to change your settings (in System Preferences) so the period is the decimal separator or use text format for the cell.

Which is the decimal character in use in your system ?

If you don't know, in an unused cell insert the formula =11111/2 so you will see the decimal character and the thousand separator.

Here with my French settings I get 5 555,5

Yvan KOENIG (VALLAURIS, France) jeudi 25 août 2011 21:02:41

iMac 21”5, i7, 2.8 GHz, 4 Gbytes, 1 Tbytes, mac OS X 10.6.8 and 10.7.0

My iDisk is : <http://public.me.com/koenigyvan>

Please : Search for questions similar to your own before submitting them to the community

To be the AW6 successor, iWork MUST integrate a TRUE DB, not a list organizer !