Entering dollar and cents amounts without entering decimel p

[mfligelman]

I have been creating and using Excel spreadsheets for several years......and I had properly formatted the cells to enter a dollar amount (ie 1057) and the number appeared in the cell as 10.57.....that is until I installed a new hard drive, and went from Windows 98 2nd Edition to Windows XP with service pace 2. Now, unless I enter the figure ENTERING THE DECIMAL POINT, I get either a row of XXXXXXX, or the figure comes up entering a decimal point with 2 zeros following it. Please let me know if there is a reason for this considering the aforementiond.....I have spoken to several knowledgable people who have told me that I was dreaming about ever having entered that numbers as I described......I know that I was not dreaming.....I know that it happened...just do not know why it stopped...any help would be appreciated.....by the way.....Excel is part of my Office 2000 Disk.....thank you

 

[Yogi Anand]

Re: Entering dollar and cents amounts without entering decim

I have been creating and using Excel spreadsheets for several years......and I had properly formatted the cells to enter a dollar amount (ie 1057) and the number appeared in the cell as 10.57.....that is until I installed a new hard drive, and went from Windows 98 2nd Edition to Windows XP with service pace 2. Now, unless I enter the figure ENTERING THE DECIMAL POINT, I get either a row of XXXXXXX, or the figure comes up entering a decimal point with 2 zeros following it. Please let me know if there is a reason for this considering the aforementiond.....I have spoken to several knowledgable people who have told me that I was dreaming about ever having entered that numbers as I described......I know that I was not dreaming.....I know that it happened...just do not know why it stopped...any help would be appreciated.....by the way.....Excel is part of my Office 2000 Disk.....thank you

Hi mfligelman:

Welcome to MrExcel Board!

Let me respond to your dilemma with the following illustration ...

Book1
	A	B	C	D	E	F
1
2				I entered 1057 (cell B4) in an area above row
3				5 where the entries were made as one would
4		1057		normally do and I got 1057
5
6
7				then when I got to an area below row 5,
8				I invoked TOOLS|Options| Edit|Settings --
9				Fixed_decimal_places 2. After that entering
10		10.57		1057 (cell B10) meant entering 10.57
11
Sheet1

and I am using EXCEL 97 -- this is an EXCEL feature and no it is not an EXCEL version thing.

I hope this helps!