Over 1 million tech questions and answers.

Can't change Currency Format

Q: Can't change Currency Format

My currency format is displaying xxx.xxx,xx. It's really messing up my financial software (Quickbooks). I have gone into the control panel/Regional and Language Options/Customize Regional Options/Currency and found it is set up incorrectly. However, I'm unable to change the settings to xxx,xxx.xx. I don't have any choices in the dropdown lists. The separator only displays . (period) and the decimal point is , (comma). Is there some other setting I need to change in order to be able to change the currency format?

Windows 7 Home Premium 64 bit.

RELEVANCY SCORE 200
Preferred Solution: Can't change Currency Format

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Can't change Currency Format

I believe that you should be able to just edit the Decimal and Digit grouping symbols. Options would presumably be offered in the drop down boxes only if you have more than one locale installed.

Jim

Read other 1 answers
RELEVANCY SCORE 78

I only ever use ?, $ or ? when formatting currency.

Is there any way to set these three to be first on the drop-down (Format Cells>Currency>Symbol) list or else hide/delete all the others?

T

Read other answers
RELEVANCY SCORE 66.8

I'm in Mexico and I have Windows 7 and Office 2007, both in spanish. In Excel,
my currency format displays in Euros, with commas as the thousands separator.
I want Mexican pesos as the currency, and period as the thousands separator.
I've tried installing the spanish (Mexico) language pack in Windows 7, and setting
pesos (Mexico) as the currency in Excel Options under the Office Button, but
I can't seem to get it right.

I'm guessing that somewhere I'm configured as if I'm in Spain, not Mexico, but
I can't figure out how/where. Can someone step me through how to configure
this correctly in Windows/Excel, or point me to a link how to do this?

Thx, Gus

A:Currency Format

Here is the solution for the Thousands separator:






Quote:
By default, Microsoft Excel uses the system separators that are defined in the regional settings in Control Panel. If you sometimes need to display numbers with different separators for thousands or decimals, you can temporarily replace the system separators with custom separators.
Click the Microsoft Office Button , and then click Excel Options.
On the Advanced tab, under Editing options, clear the Use system separators check box.
Type new separators in the Decimal separator and Thousands separator boxes.
Tip When you want to use the system separators again, select the Use system separators check box.
Note For a permanent solution, you must change the regional settings in Control Panel.


When you say that you want Mexican pesos as the currency, do you want to see $ or MXP as a prefix?

Read other 3 answers
RELEVANCY SCORE 66

I have no javascript programming experience, except for copying/pasting/customizing the freebie scripts I find into my HTML, so please be nice to me!

I am working on a simple order form, with fixed costs for three items. Variables are the quantity ordered, and the shipping, which are to be entered by the customer. I use a .php form to email the order to the customer, with nothing fancy--just print the fields from the page. (I might add, this form is hosted and will be processed when it is working, on a secure server.)

The problem I have is that when the "calculate your total" button is pressed, depending on the shipping cost, sometimes I get a very long number after the decimal. It seems to happen when a shipping amount ending in the number "7" is used, e.g., "17.77". I want it to calculate/print out with only two characters after the decimal point. What am I missing?

Below are copies of the code I have used. Thank you in advance for your help!

Carrie

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Script for calculations:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
<SCRIPT language="JavaScript" type="text/javascript">
<!--

function compute_total(form)
{
form.subtot1.value=((form.itemcost1.value - -form.ship1.value) * form.quant1.value);
form.subtot2.value=((form.itemcost2.value - -form.ship2.value) * form.quant2.value);
form.subtot3.value=((form.itemcost3.value - -form.ship3.value) * form.quant3.value);
form.total.value=form.subtot... Read more

A:javascript currency format

Can anyone out there please help me? I know it is probably a very elementary problem, but I can't seem to find the answers I need elsewhere online.

Thank you!
Carrie

PS: I also want to learn javascript myself. Can anyone suggest a good book.
 

Read other 1 answers
RELEVANCY SCORE 64.8

I want to show a $ amount in cell G2 which will display Credit $209.80.

The figure of $209.80 is present balance however, this will change from month to month.
It will always be a Credit figure and will be the figure shown in C30.

Have tried

Code:
="Credit " &C30
However it comes out without the currency symbol and is to 4 decimal places rather than the two I need.

What will show "Credit $209.80"?

Thanks

Pedro
 

A:Format for Text and Currency excel 2003

Read other 7 answers
RELEVANCY SCORE 63.2

Hi

I'm trying to change the display currency for a Win 7 user a/c but it keeps returning to USD.
Would really appreciate some help on this.
 

Read other answers
RELEVANCY SCORE 62

Hello,

I have a file with about 30 tabs and I need to change the currency symbol from C$ to A$ on all tabs in all cells.
There is also US currency in my file, but those are indicated as just $.
For example: $500 C$600 should be changed to $500 A$600
The columns are not identical, therefore I can't select all tabs and columns and format the numbers that way.
Does anyone know if there is another way I could do it all at once with one step?

Thank you in advance.
Fern.
 

A:Change currency symbol on several tabs in Excel

if you goto find
use replace
C$
with
A$
Options > Workbook
it will change every C$ on every cell

is that what you need ?
 

Read other 1 answers
RELEVANCY SCORE 61.2

Hi everyone, this is my first post so please excuse me if i blunder!

I have a small problem that im trying to solve. I have a work book that totals up various figures. I would like to have a drop down box where i would select a type of currency ($,, etc) that would display the figures in that particular currency moniker.

so if i selected from the drop down list the figures in the cells would have '' in front of them, etc.

is this at all possible ? i.e. simply ?

Thanks in advance for any advice,

L:
 

A:Drop down list to automatically change figures currency

Read other 13 answers
RELEVANCY SCORE 55.6

I have a query where a number field is multiplied by a currency field. The expression is numerically correct but is not expressed in currency format. How do I change that?
 

A:number field multiplied by currency field express in currency

Read other 8 answers
RELEVANCY SCORE 50.8

I have my files in firefox format..If i want to change the format for only my files without effecting some other files which are in same firefox format...what i need to do?
 

A:how to change files from firefox format to another format

The simple and obvious answer is to just change the files that you want changed and leave the others alone. But you must have something more in mind.

What is "firefox format"? To what format do you want to change? Using what tool, application or method?
 

Read other 1 answers
RELEVANCY SCORE 44.4

Hello,
Okay I would like to know if this is possible.
I currently have several forms. I am creating a new form using the form wizard. So I click on insert->form. I go to form wizard. click ok. I add the needed fields. click next. it asks me to form with "subforms" or "linked forms". I click subforms then next. This next slide gives me four options "1 tabular" "2 database" "3 pivot table" "4 pivot chart". I want to choose 1 tabular, because it is the best for me, but I would like the layout to be slightly different. The top portion places the fields vertically across the form, and the middle portion places the records horizontally.
I would like to make the middle portion place the records vertically instead of horizontally. Is this possible?
I tried to modify it using the click and drag method, but then it would only let me access one subrecord at a time instead of all 3 subrecords.

Thank you for you time and effort.
Sincerely,
David
 

A:change in format

Read other 8 answers
RELEVANCY SCORE 44.4

I copied a song from a cd to my computer. it is a WMA file. How can i change it to a wave or MP3?
Also, how do i change a MP3 to a WAV?
 

A:Format change

Read other 7 answers
RELEVANCY SCORE 44.4

I have music in MP3 format that I want to play in my car sterio. Can it be change so as to burn a new CD for this?
 

A:Change MP3 format

You don't have to change them. You just fire up your favorite CD burning application, use a CD-R, (not CD-RW) and drag-n-drop them onto an audio compilation and burn them. Presto, you have an audio CD.
 

Read other 3 answers
RELEVANCY SCORE 44.4

window xp service pack3[sp3]

Read other answers
RELEVANCY SCORE 44.4

Hello guys
 
I formatted my DVD-RW disk  to run as USB.
 
 I have erased the file.
 
Now I need to reformat the disk to run as DVD.
 
What is the procedure please ?.
 
Thank you.
 
Caston
 

 

A:Change format from USB to DVD

I have no idea what you are talking about...a DVD disk (the actual media) can only be formatted for use in an optical drive.  It can be used as a storage drive in the same manner that a hard drive is...but that involves packet-writing software.
 
Packet-Writing
 
Is this what you mean?  If not, please explain and tell us how you "reformatted to disk to run as USB".
 
Louis

Read other 3 answers
RELEVANCY SCORE 44.4

can anyone suggest how I change format from the american to european video system.
 

A:format change

Read other 11 answers
RELEVANCY SCORE 44

Hi there

I am wanting to transfer I photo I have onto canvas. I scanned the picture and saved it onto my computer where it automatically saved it as a pdf file with no option to change it. Now when I went to download it onto the website that will be making the canvas print it will not allow any pdf files. Is there anyway to change the format so I can get my canvas? cheers
 

A:picture format change

There are a few online services which will convert PDFs to graphics files, such as JPEGs, for free. Here's one example you can try.
 

Read other 3 answers
RELEVANCY SCORE 44

Can a document hold its original formatting when it is downloaded, ie a resume?

Read other answers
RELEVANCY SCORE 44

I do know a good deal about Access but can not think where to start with this problem. I have dates stored as 20000928, ie. yyyymmdd in the text data type. I need to convert these into a standard date format eg. 20000928 becomes something like 28/09/2000

Can anyone help?
 

A:Access-change format

This expression in a query will arrange it like you want but, I'm not sure if I'm missing something as far as proper formatting is concerned.

ConvDate: Right([Yourdate],2) & "/" & (Mid([Yourdate],5,2) & "/" & (Left([Yourdate],4)))

Ziggy
 

Read other 3 answers
RELEVANCY SCORE 44

how to change file format from .rar to .exe?

A:how to change file format from .rar to .exe?

Welcome to SF!

You will need to extract the rar file, and create a new zip file. Use Rar Extract Frog or a similar program to extract the RAR. You can then create a new zip folder from the New menu on right-click.

Hope this helps,
~Jonathan

Read other 9 answers
RELEVANCY SCORE 44

I have a file with a .mpeg extension. i want to burn it to disk so i can send it to my family and they can view it by putting it in our DVD player and watch it on the TV. how do i do it?? the .mpeg file will not play in our DVD player, but it will play in my computer.
thanks.
 

Read other answers
RELEVANCY SCORE 44

Hi
I need to change a image ext tif to a jpeg or something else.
the tif is not valid for the upload. thanks, gina
 

A:change file format

OPen it in your viewer FIle Save AS and select the other format. You should be able to do that with paint.
 

Read other 3 answers
RELEVANCY SCORE 44

Hello there

I am unable to get my Windows 8.1 installation to use anything but the US keyboard format, despite the fact that all my keyboard and regional settings are UK.

In particular, I go into the "Keyboard" application in Control Panel, and English (United Kingdom) is listed as the first item.

N.B. English (United States) is listed as the 2nd item in this list, and I can't remove it (I remove it from the list, but it is put back in the list when I restart the keyboard application).

Whatever I do, the keyboard layout remains the same - for example, the " and @ keys are the wrong way round.

A:Can't Change to UK Keyboard Format

What have you got here - Language and then options.

Edit - can you do a screen print Screenshots and Files - Upload and Post in Eight Forums and welcome to eightforums

Read other 7 answers
RELEVANCY SCORE 44

can anyone tell me how to change an avi file to mpeg as when i try to play avi file media player 10 wont play it somthing to do with codec ??????

A:change file format

You need to download the codec. Even the conversion programs (which by the way take hours to work) need the codec to do what they do. I recommend the XVid codec.

Read other 5 answers
RELEVANCY SCORE 44

Evening All:

    I have 2(SanDisk 32Gb) pendrives that are formatted in NTFS. This presents a problem. They are "recognized" as HDD's and thus, cannot be "ejected" in normal manner using "Safely Remove Hardware" icon. When I try
this, there is not an 'eject" to click. I believe this is because the NTFS format makes[reads] them a HDD and, of course, HDD's cannot be "ejected". So, is there a command that I could run that would change the formatting from NTFS to FAT32
without having to empty all the contents of the drives, re-format, then re-install all the data?
THANX:
Rick

Read other answers
RELEVANCY SCORE 44

Hi All
Is there any way to give access to end users only to change Date format(from dd/mm/yyy to mm/dd/yyyy and vice versa). I don't want them to change the date just the date format.
Regards
Bharath

Read other answers
RELEVANCY SCORE 44

I'm trying to change a file I made in windows movie maker to make the file an AVI file?
Does anyone know how I can do that?
Do I need a special program?

Any help appreciated..

Daniel...........Toronto
 

A:Trying to change format from Windows to AVI?

Read other 8 answers
RELEVANCY SCORE 44

Hi All

I had a problem with my laptop and i lost my administrator icon, i'm just working as guest.
What i want know is to know if i format my laptop, will i lose the PCID??
I have program that was set to this computer and i'm afraid to format my laptop.

Who can help me please???

I will be waiting a feedback

Jannei

Read other answers
RELEVANCY SCORE 43.2

This may be helpful to some of you? I was irrated that WLM only displayed the day and month in its boxes. I have discovered that WLM takes its display settings from the 'Short Date' as setup in 'Control Panel', 'Regional & Language Options'. You can only use the preset options available in the drop down box but at least my boxes now include the year!
Hope I'm not repeating something that has already been covered in this forum only my search didn't reveal that?

A:Change Display Date Format WLM

All the date formats in the "R & L Options" drop-down boxes include the year, so I don't understand which WLM boxes were not showing the year or how it could be fixed by making another "R & L Options" choice that also included the year.

Read other 2 answers
RELEVANCY SCORE 43.2

I have a column of dates in dd/mm/yyyy format, yet nothing I do lets me sort from oldest to newest.
Basically it doesn't recognize the column as having only dates, therefore only allows me to sore from A-Z.
I have tried what was posted on a few other forums, such as copy-pasting the column in notebook and
then back to excel. I've also tried the text to column wizard, with no help.
I've tried creating entirely new excel files and copy-pasting the dates there, either directly
or copying to notepad and then to the new spreadsheet. Nothing seems to work.
 

A:Can't change date format properly

they are not formatted as dates and probably text

can you attach here ?

click on the date cell and change the format to number or general
you should see a number like
42293
which is today 16th Oct 2015
 

Read other 5 answers
RELEVANCY SCORE 43.2

Hi people, I'm new around these parts, but I'll try not to be an annoyance.

I had a client come in yesterday with a problem with MYOB displaying the wrong date format. Specifically, it displayed it in MM/DD/YYYY format, instead of DD/MM/YYYY.
Looking at MYOB support, it says it takes the Date format from the computers regional settings, and will change as you change the settings.

The machine is Windows XP SP2, it has no other errors that I've noticed. The machine is only a few months old.

We changed the regional settings, with no effect. We then went to customise the date format. If we made any chages, even selecting something from the dropdown boxes, it would say 'Invalid character' and not allow the changes. I hadnt added any characters, just selected one from the dropdown box. You'd think that they would be correct.

Any thoughts would be appreciated. I'm hoping to have the machine back in the office next week to work on it.

A:Unable to change Date Format

welcome

see if there is a bios update available for that motherboard

good luck

Read other 1 answers
RELEVANCY SCORE 43.2

Is it possible to change motherboard and proc without reformat ? Perhaps a repair install ? Possible with windows 7 x64 or not ? Windows 7 x64 7137 BTW.

A:Change Mobo and Processor without format ?

  
Quote: Originally Posted by ghost301


Is it possible to change motherboard and proc without reformat ? Perhaps a repair install ? Possible with windows 7 x64 or not ? Windows 7 x64 7137 BTW.


Welcome to Win7Forums Ghost!

It is definately not true that you have to reinstall Windows with a MOBO/Processor change. 7 is smart enough to detect the processor and use it, the only issue might be the MOBO. 7 will more than likely load a default driver for it but you may want to load the manufacture version to make sure you can use all the features of it.

Hope This Helps
Zidane

Read other 9 answers
RELEVANCY SCORE 43.2

Im trying to play skyrim but the thing is it keeps crashing at the logo. I search up fixes, and apparently i have to change my default format for my headset to cd quality but for some reason it wont let me change it and im left here crying in the corner xD plz halp?

Screenshot by Lightshot

A:Can't Change Default Format for Headset

Without PC spec's hard to try and assist you. Although this is a possible problem with the headset mode, its really more a gaming issue. Posting in the gaming section is suggested.

Also, here is how to post screenshots in this forum:
Screenshots and Files - Upload and Post in Eight Forums

Read other 1 answers
RELEVANCY SCORE 43.2

Can anyone tell me what could be the reason I can't change the Default Format in the Advanced Speaker Properties?

A:Can't change sound Default Format

Maybe because it's already on its default format.

Read other 6 answers
RELEVANCY SCORE 43.2

Whenever I save something from the internet to a text file and open the file with Notepad, it will bunch up all the words and sentence into a group of words. Example:
 Notepad.JPG   52.65KB
  11 downloads
 
However, when I open the file in Wordpad, it will come out like this:
 Wordpad.JPG   57.71KB
  10 downloads
 
So I was wondering does anyone know why Notepad do this. Also my computer in a Window XP.

A:Why does Notepad change the format of it's content?

This has to do with how Notepad recognizes the end of a line. In Notepad, only a carriage-return character followed by a line-feed character is interpreted as the end-of-line marker. Other systems like Mac OS X and Linux use only the line-feed character. Whenever Notepad opens a file that uses only the line-feed character (for example, if the file was originally written on a non-Windows system) it doesn't detect a proper end-of-line marker and so interprets the text as being on a single long line.
 
Wordpad supports many end-of-line conventions, which is why it can display both the Windows and Mac/Linux conventions correctly. You might want to look at one of the many Notepad replacement editors available online. My favorite is Notepad++, which includes tools to convert a file between different end-of-line conventions.

Read other 2 answers
RELEVANCY SCORE 43.2

I have been using Aimersoft DRM Media Converter to change the format of programmes I have downloaded onto the BBC iPlayer so they are then suitable to put onto a memory stick for using, at any time, at a later date in my caravan. The BBC have recently changed the format of the iPlayer and I cannot find a way to convert the format. Can any one out there point me in the right direction!?!

A:BBC iPlayer - change of format problem

I'm no expert but downloaded programmes from BBC iPlayer have availability rights which is why they are made to expire after 30 days. My guess is that the format was changed in an effort to prevent people converting and saving them for longer than the 30 days. Saying that I expect someone may know of a converter that has overcome this.

Read other 1 answers
RELEVANCY SCORE 43.2

I want to change my view of settings back to the way it looked in win 10 originally. Now I get a list with icons. I just want the original back. I don't know how it got changed!
Thanks.
Sam

Read other answers
RELEVANCY SCORE 43.2

In Vista, it is possible to change the default format (16000 Hz, etc) for a set of speakers or a headset by going into the Speaker Properties of the device and clicking on the Advanced tab.

I've tried looking everywhere for a way to do this in XP, but haven't found anything yet. Is it possible, and if so, how do it do it?

Read other answers
RELEVANCY SCORE 43.2

everytime i play music or movie sound is crapy i have to open sound properties and switch default formats ie 24bit 44100 hz to 48000 hz or visa versa then sound is great and if i close app then open again same thing sounds like crap until i toggle

A:why do i have to change default format (sound hz )

Is your sound output via the headphone jack or are you connected via HDMI?

It could be a conflict between the Realtek Sound Manager and the Windows settings.

Read other 9 answers
RELEVANCY SCORE 43.2

Could anyone please tell me how I would change Real Player into MP3 player format. This seems to be a difficult question for this forum.
 

A:HELP !!! How to Change Real Player to MP3 format???

All Sound Recorder XP
 

Read other 1 answers
RELEVANCY SCORE 43.2

I cant seem to find any program that will allow me to change files that I can play in Real Player to mp3 fprmat. Does anyone have any suggestions? Any help would be appreciated
 

A:How to change from Real Player to Mp3 format

Please don't multiple post for the same problem.
 

Read other 2 answers
RELEVANCY SCORE 43.2

Hi
I want change format Time& Date but when i change country to a format special for example English (united state) after click OK button at once return to previous format
help me!

A:Not Change Format Time & Date

Time Format - Change

Date Format - Change

Date and Time - Change

Format Regional Language - Change

Read other 1 answers
RELEVANCY SCORE 43.2

How to change/format harddrive on mac format in windows 7?
Tried some softwares but did not help. Thanks

A:How to change harddrive into mac format in windows 7?

your question is not that clear. Normally if you want to format a drive, all you have to do is to go into win7 disk management, delete the partition, then format.

are you wanting to format the drive to use on windows or mac computer?

Read other 4 answers
RELEVANCY SCORE 43.2

Is anyone else having problems with this app? I installed it two days ago, selecting my currencies. When I run it, it shows "refreshing" and then says "unable to update rates - come back later". It hasn't given any currency rates since I installed it. Uninstalled/reinstalled with the same results.

A:XE Currency App Not Working

I am also having the same problem. Even reinstalled the OS. Worked fine until I updated my PC and installed other software.
What's the solution? Is it a virus or the app problem?
Oh btw, live updates fine.

Read other 1 answers
RELEVANCY SCORE 43.2

The currency calculator in my side bar has worked fine for the last year now suddenly will not conect and shows "bad number" how do I get it back to normal. All help appreciated

A:Currency Calculator

Hello Sparrow,

Welcome to Vista Forums.

You could try doing a sys. restore to a point before it stopped working. Info here if needed:
System Restore - How to

Also you could try uninstalling the gadget and then reinstalling.

Hope this helps.

Gary

Read other 4 answers
RELEVANCY SCORE 43.2

I have recently developed a strange problem I was wondering if anybody can shed any light on the problem. My browser now replaces most of, but not all, the £ signs on websites with the letter J. I have checked the regional settings in the control panel and confirmed that the £ sign is still available whilst using Microsoft Office applications. Any ideas?

Regards

Jim Mclean

A:IE currency codes??

Tools./ internet options/ general / fonts.
Sounds like it is set to a font which does not include
the ? sign
Might also want to check on the accessibility button and make sure it does not have ignore the fonts on web pages.
\

Read other 1 answers