- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2006 May
- If I type in 3, I get .003 after hitting enter. All .xls files.

Subject: | If I type in 3, I get .003 after hitting enter. All .xls files. |

Posted by: | Stu |

Date: | Wed, 10 May 2006 |

Every .xls file I open or create, this occurs. If I type in a number & hit

enter, that number divided by 1000 appears. This does not appear to be

related to formatting or a formula, but rather some global "setup" or

"options" feature in my desktop. In my office, no one else experiences this

& our IT guys have no answer for me.

I can get the number entered correctly by typing ie. 3.0 to get 3. But if I

type 3, I'll get .003 . If I double-click into a cell which contains 3, then

<enter> I'll get .003 .

This could actually be useful at times... I would like to know how to turn

this ON & OFF.

Any idea?

- Re: If I type in 3, I get .003 after hitting enter. All .xls files. posted by Bob Phillips on Wed, 10 May 2006
- Re: If I type in 3, I get .003 after hitting enter. All .xls files. posted by David Biddulph on Wed, 10 May 2006