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

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.
 
D

Dave Peterson

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.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top