Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Office X - excel: problem with characters shifting places

Apr 5, 2005 2:50PM PDT

I am using a MAC powerbook.
Problem: when using excel, each time I type in a number into a cell, the number shifts two decimal places; i.e.: type in 45, it becomes 0.45. If type in 789, it becomes 7.89. I have tried everything such as format cells (no problem), restarting the computer and re-installing the software, but nothing seems to work. Can anyone offer a solution? Thank you in advance.

Discussion is locked

- Collapse -
Looks like it's in dollar formatting.
Apr 5, 2005 9:32PM PDT

Reinstalling does not remove user preferences. And you didn't write exactly which format the cells are in.

Is this new turf for you?

Bob

- Collapse -
It's in general format
Apr 6, 2005 11:59AM PDT

Not too familiar with Excel, but the format is general. i tried to change it to number and decimal and other selections and then rechange it back to general, but the same thing happens. any ideas on what i might do to resolve this?

ym

- Collapse -
Even the general format could have been edited.
Apr 6, 2005 10:22PM PDT
http://uts.fiu.edu/images/TrainingDocs/dwe2701.gif while the PC image shows the usual box. It's possible the OS SYSTEM settings can change the general formatting or someone editted the general setting. Again, you have to uninstall Excel, and remove any extra Excel files to undo this one. Or understand how and what Excel uses from the OS settings for the general format.

I wish there was a do-this answer, but of the few times I've run into this one, the answer or repair was never the same.

Bob
- Collapse -
will give it a try
Apr 7, 2005 9:26PM PDT

thanks for the advice. hope it works...don't be surprised if i'm back though...
cheers.