H
HK@HKHK
control panel->regional settings->Currency->currency
symbol=SGD$
However,when i open a .csv file containing a dollar
sign "$"
my excel shows US$XXXX.XX
Everytime i open the .csv file, i need to correct the
format to the whole column.
How to fix it?
symbol=SGD$
However,when i open a .csv file containing a dollar
sign "$"
my excel shows US$XXXX.XX
Everytime i open the .csv file, i need to correct the
format to the whole column.
How to fix it?