Anyone good with excel?

A

Andy Tregaskes

Can anyone answer this question please...........

Is it possible for a spreadsheet to appear on one pc without currency signs and then when it is e-mailed to another user for currency signs to show on their pc?
 
D

Douglas J. Steele

You'll probably get a better answer if you post to a newsgroup related to
Excel (they all start microsoft.public.excel)

This newsgroup is for questions about Access, the database product that's
part of Office Professional.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)


Andy Tregaskes said:
Can anyone answer this question please...........

Is it possible for a spreadsheet to appear on one pc without currency
Click to expand...
signs and then when it is e-mailed to another user for currency signs to
show on their pc?
 
V

Van T. Dinh

I am not good with Excel but the display of the currency sign in Excel (and
other Office application) depends on the Regional Settings (including
settings for date/time, number, currency, etc...) of the OS. Thus, if 2
users set their OSs differently, you will have different display.

BTW, this newsgroup is for Microsoft Access, a database development
software. If you want more people good with Excel, you should post to one
of the Excel newsgroups, not Access newsgroups.

--
HTH
Van T. Dinh
MVP (Access)



Andy Tregaskes said:
Can anyone answer this question please...........

Is it possible for a spreadsheet to appear on one pc without currency
Click to expand...
signs and then when it is e-mailed to another user for currency signs to
show on their pc?
 
E

ELROYAL

Try setting a macro routine that when the file
(spreadsheet) is opened at the receipient, the field that
does not have a dollar sign to be formatted (on open) to
dollar sign. Select record macro, point to your field,
select format, select numbers, then select currency, then
end your macro recording. Set the file to run macro at
startup or open.
-----Original Message-----
Can anyone answer this question please...........

Is it possible for a spreadsheet to appear on one pc
Click to expand...
without currency signs and then when it is e-mailed to
another user for currency signs to show on their pc?
 
Top