No decimal points displayed 1

[choppysuey]

Hi all,

I seem to have something set incorrectly in Excel 97. All my spreadsheets no longer display the decimal points. This includes any new ones that I create. The cell is formatted as number with two decimal places. However a 5.25 just shows up as 5 25. Instead of a decimal a space appears. Anyone know which option(s) I need to set.

thx for the help.

 

[mbarron]

Goto Regional Settings in your Control Panels. On the Number Tab there is an option to change the decimal symbol. You'll have to close Excel for the change to take effect.

Mike

 

[SkipVought]

Thanx! mbarron. I looked ALL OVER -- apparently NOT! Skip,
metzgsk@voughtaircraft.com

 

[chopsuey]

Yep, that was it. Somewhere along the way the decimal setting was replaced by a blank. Thx for the help.