I enter 6 and excel puts 0.06 in the cell, do I have virus?

[Tmoody]

I have a problem in excel running in OSX on my imac. I
opened a new spreadsheet and for a cell formatted as
numeric, excel multiplies the input by .01 and puts that in
the cell. There is no formula in the cell.

Amy suggestions as to what is wrong?
Thanks

 

[Bernard REY]

Tmoody wrote :

I have a problem in excel running in OSX on my imac. I
opened a new spreadsheet and for a cell formatted as
numeric, excel multiplies the input by .01 and puts that in
the cell. There is no formula in the cell.

Preferences > Modification > Fixed decimals

Note this is an "Application" setting, this means it will apply to any
workbook until the setting is modified.

 

[Tmoody]

Thanks for the response, but I can't seem to find the
modifications preference.
The preferences I have available are:
view, save, calculation, edit, general, transition, custom
lists, chart, color.

I'm running excel v. X on a mac.

Additional clarification would be appreciated!

 

[Bernard REY]

Tmoody wrote :

Thanks for the response, but I can't seem to find the
modifications preference.
The preferences I have available are:
view, save, calculation, edit, general, transition, custom
lists, chart, color.

It'll be "Edit" pane then. Guess you'll have found by now, but one never
knows. I'm using a French version, so I sometimes do not find the matching
words. Hope it helps you out this time


---------------------------------------------------------
Please reply to the newsgroup, and within the same thread.
Merci de répondre au groupe, et dans l'enfilade.

--
Bernard Rey - Toulouse / France
MVP - Macintosh

 

[tmoody]

it was the edit pane - thanks again!

-----Original Message-----
Tmoody wrote :


It'll be "Edit" pane then. Guess you'll have found by now, but one never
knows. I'm using a French version, so I sometimes do not find the matching
words. Hope it helps you out this time


---------------------------------------------------------
Please reply to the newsgroup, and within the same thread.
Merci de répondre au groupe, et dans l'enfilade.

--
Bernard Rey - Toulouse / France
MVP - Macintosh





.