A Square is Showing Instead of a Period for a Currency.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In my spreadsheet, a square is showing in the currency amount rather than a
period. For instance, if I need to have
$400,000.00 in the cell, it gives me $400,000Square00 in the cell. I can’t
draw a square from the keyboard here, so I typed in the word SQUARE here
instead of drawing it out. This only happens to one user’s login with admin
rights. If I login as local admin to the PC, to access the same excel file,
it doesn’t happen. Anyone any idea? I will appreciate it.
 
I'd look in windows regional settings.

Windows start button|settings|control panel|regional settings applet.

Look at the currency tab.

Check for the decimal point.

(and while you're there, check the decimal point on the Number tab, too.)

(But it's just a guess.)
 
Back
Top