Excel 2010 Keeps Changing Format From Number To Currency

when i receive an excel file in an email, i open it and all numbers in the cells would be changed to curency with $ sign.
in the original file dells are formated as numbers .
does anyone encountered that issue?

please help

Free Excel Help Forum

- Ask any question about Excel and have it answered in no time.

Similar Excel Tutorials

Display Numbers, Dates, & Times in the Correct Format in Excel
In this tutorial I am going to look at Number formatting. Number formatting allows you to change how numbers are di ...
Format Any Element of a Chart in Excel
In this tutorial I am going to go through the Format tab in more detail and show you how to Format every element of ...
Get the Last Day of the Month in Excel
How to get the last day of the month, including the date and day of week, for any date in Excel.  This method allow ...
Stop Excel from Changing Numbers to Dates or Anything Else
How to stop Excel from automatically changing numbers into anything other than what you typed, such as changing a f ...

Helpful Excel Macros

Format Cells as a Currency in Excel Number Formatting
- This free Excel macro allows you to quickly and easily format a selection of cells in the Currency number format in Exce
Open any Program from Excel
- This free excel macro allows you to open any program on your computer from excel. You can open a media player, file vie
Open a PowerPoint Presentation from Excel
- This free macro for Microsoft Excel allows you to open any PowerPoint presentation from excel. You can change the file
Email Current Workbook & or Other Attachments
- This macro will send the current workbook in an email through Microsoft Outlook. The Macro allows you to send the most
Open a Word Document from Excel
- This Microsoft Excel macro will open a Microsoft Word document from excel. With this macro, you can open any word docume

Similar Topics

I have created a table for following payments. So each row has, few cells formated as currency.
Then I open the same file on other computer (other excel), and format of number changed from $11.000,00 to $ or something.
How can I solve this?


After exporting numbers from Quickbooks into Excel (2003), I tried changing
them to a currency format, but the numbers refuse to change.

Original number 3000
What I want $3,000

I also tried General, Text, et all.

Any idea what is going on here? How do I get it to conform?



Hi all,

I have a spreadsheet that is use to form tables using macros. However, Iuse the same spreadhseet for all the different tables I creat and a problem arises when for one report a column will have a cost in it (want the column or cells to be formated as currency).

Then a clear that and make another report and the old cost column has a account code in it that is amde up as numbers.

Unforunately due to the previous formatting the account code is changed to currency.

The question is: what vba code can I use, for example on column "A" of a spreadhseet that will change the format of that column to what i need. Such as number, currency, text etc.

Thanks in advance


When opening a .CSV created from a third party software, one of the columns
is converted to date format. The numbers are imported in #/# format. and
Excel changes most of the numbers to 2-Jan, 3-Jan etc... This would not be
that big of an issue if I could simply set it back. Clearing format or
changing to text converts it to a 5 digit number.

The only way I have found to get it to work properly thus far is to open a
blank sheet and import data and setting the column to text prior to import.

I would like to find a way of opening the CSV file without all the extra
steps. Is there a setting that can be turned off?

Thanks in advance,

In my shop, we have a process which runs few "JCL's" on mainframe environment and prepares some data in the report format (basically just a text).

Then we send that file as attachment to users. the attachment goes as CSV file.

My rquirement is ----

I want to format this report. Like changing color of Title / adding subtotals etc.

Currently when users receive csv file, they open it in excel they can see the plain data and have to format it manually.

Is there any way i can preset this format. So whenever user will open this CSV file, he will automatically see the formated data ...


I'm pretty average with Excel, so there may be a not too diffictul solution to this issue, but I have turned to a dedicated forum as I simply can't find it...

I have data I've imported into excel. One column was basically numbers, with 5 additional characters at the end of each value. I used the LEFT command to strip those out (yay me and the help file!)

What I'm left with is the numbers. BUT, there is an issue. Every number is preceded either with a - or a + (depending, obviously, on whether the number was negative or positive).

I'd like to just be able to do normal calcuations etc with the numbers, but the + signs are causing obvious grief. I've tried changing the cells to number, to text, to general etc. I also figured I could just do a search and replace, search for a + and replace with nothing, and then convert all the cells to numbers. But that doesn't work. According to the Find item there are no +s in my spreadsheet.

I assume because the + symbol has significance excel tries to treat it differently and that is causing my issue? Is there a way around this?

Oh, and I'm using Excel 2007...

Any help would be greatly appreciated!


Apologies if a thread already exists on this (Haven't found it )

I use Excel 2010. I encounter this problem on only 1 of my files:

Every time I open it, the number formatting is changed from numbers into date . I always have to change back to numbers.

It is a large file with lots of data organized in database from which I get Pivot Tables in different tabs. I get the data monthly from a site and receive them in CSV. I usually copy / paste as value (no formatting) and work from there. When done, I save (.xlsx). When I open again, still formatted in dates. Not sure what to do here.

Thx in advance for helping...


Hi. I have a problem with currency-fields. I have a FM in SAP. It returns a table which contains 2 columns with amounts (type: CURR). In SAP everything is ok.

Values in SAP are for example: 26,451.99

When I export it into EXCEL it's received as string. When I display that value using:

itab(row, col) -> I receive 26,451.99 as string and when I want to sum it up I receive 0, even if I change cell-format into currency *,XX

Val(itab(row, col)) -> I receive a number but it's shortened into 26451

what should I do to transfer data properly? That is to receive 26,451.99 as a number (currency)? Greetings. P.

I have a small excel file (200k) which worked fine until i changed the file name (I cannot remember the original name as it was just letters and numbers which was the reason for changing the name!). Now it will not open and upon trying several Excel recovery programs some of them told me it was a stream read error' and the recovery failed. Any advice or is this file a write off?

I work with an accounting software primarily for schools, churches called Logos Management Software. It has General Ledger, A/P and Payroll modules, Reporting and more. Reports can be exported to Excel which I do regularly.

Today I imported an income and expense report from the Logos software. In the imported Excel spreadsheet the amounts/numbers in the cells are left justified with $ sign, commas and decimal at 2 places. Until today’s import, I have had no problem highlighting the amounts/numbers, right click, select Format Cells, select Number, select 2 decimal places, comma and the numbers would move to the right and drop the $ sign.

With the report I imported today, I highlighted the amounts/numbers, right click, select Format Cells, select Number, select 2 decimal places, select comma, clicked ok and nothing happens....the amounts/numbers remained as is. What is strange is when I select Number in the Format Cells dialog box, in the Sample box the $ sign remains. I can enter a number in another empty cell and can format that number successfully.

Thanks for any suggestions.


I have two cells that I am multiplying. Each of the two cells contain formula answers. When I take the one cell and multiply it by the other cell I am not receiving the correct result. I think it must have something to do with the way my cell formatting is. Here is the scenario:

When I try to multiple the "answer" from B13 which is 46.88 by the "answer" from N13 which is $.11 I receive the answer $5.04. The correct answer is $5.16 when rounded to two decimal places.

Cell B13 contains the formula: D13/0.32 The answer that is shown in Cell B13 is 46.88 and the cell is formated as a number with 2 decimal places

D13 has the number 15.00 entered into it and the cell is formated as a number with 2 decimal places.

N13 contains the formula: O13/2000 The answer that is shown in Cell N13 is $.11 and the cell is formated as currency with 2 decimal places

O13 contains the dollar amount $215.00 and the cell is formated as currency with 2 decimal places

Cell L13 contains the formula: B13*N13 (46.88 x $.11) the answer that is shown in Cell L13 is $5.04 and the cell is formated as currency with 2 decimal places. The correct answer should show $5.16.

My guess is that somehow the two formula answers when multiplied together are somehow adjusting the decimal places so that I do not receive the correct dollar value of $5.16.

When I enter the values of 46.88 and $.11 in two blank cells and then multiply them in a third blank cell elsewhere on the spreadsheet I receive the correct answer of $5.16. That is why I think it has something to do with the formulas being multiplied by each other.

Any help would be greatly appreciated.

MOD: thread moved to Worksheet Functions Forum

I have a file in .xlsm format that I have emailed to several recipients. A few people get the error "Excel cannot open the file "filename.xlsm" because the fie format or file extension is not valid".

Most of the recipients can open the file, and so can I, so I know it's not corrupt.

I have tried saving as .xlsb and .xlsx and they can't open either of those files either.

I can't save it as an .xls extension (which has worked int he past) because this file uses too many developer tools, macros, hyperlinks, and conditional formatting, which are incompatible with the .xls format.

I have tried placing the file on a shared drive and they are not able to open that either. So I know it's not an email issue.

Also, they have sent me a screenshot of the error message, and it is clear they are using Excel 2007.

How can I fix/alter/whatever the file so it can be opened by everyone?

I know this question has been asked a bajillion times, so I apologize for the redundancy.

I am working with an Excel spreadsheet and saving it as a .csv file in order to upload to an application that parses out the .csv data as transactions. The system requires .csv files, so this is how I need to save my doc (with this extension). I have been successful at preventing Excel from coverting that long number into scientific format. I have saved as a TXT file, pasted the longer number and it displays correctly. That is all good. But I have to save as a .csv. So if I do that, close the Excel window, and then open again (as the .csv file), the numbers are back to being displayed in scientific format. I have tried creating an Excel doc from scratch and entering text in Text format, to see if this created a cleaner file. But again, the second I save as .csv, close the window and then open that file up again, that dang scientific format is back.

Does anyone have any idea of how to work around this? Once I have successfully gotten the numbers to display as the long-chain number, how can I get them to "stick" so that they don't revert back to scientific format when I reopen the file?

Thanks so much for your help!

How do you format a cell which contains currency so that the dollar sign is
placed next to the dollar amount rather than left aligned? Example: $5.00
where the dollar sign stays next to the 5, even if the column width is
increased. Thanks!


Every time I open a saved excel spread sheet I receive this error:

A document with the name 'add-in name' is already open. You cannot open two
documents with the same name, even of the documents are in different

If I open the file by using the File, Open menu and navigate to the file, I
do not receive the error. It's only when I click on the file which is on the
desktop and open it that way , do I receive the error

There are no other files open at the time. Rebooting does not solve the
problem. WE are running Windows XP SP2 and Excel 97

Thanks in advance

I have a problem that I am looking for a little help on...

I have a CSV file (comma delimited) that I am opening in Excel. One of the columns contains 8 digit hexadecimal numbers. When I open this file in Excel any of the hex numbers that have a hex "E" in the number are being converted to scientific numbers.

Example: 00089E58 is being converted and displayed as 8.9E+59

I really need these numbers to just simply display as is, even as just text. I do not need Excel to recognize them as hexadecimal or numbers at all. I tried converting the column to text after the file was opened but the scientific notations remain.

This file has ~50000 rows with probably 5% being converted into this unusable scientific number. I do not want to manually update these numbers if possible. Any help would be greatly appreciated.

Excel 2003

I have a CSV file that I will open (or import) and which has one column that contains serial numbers. The problem is that some of the numbers have this format: 123E567.

Excel promptly converts this text to a number: 1.23E+569. Even if I then change the format of the cell to text, it still keep the text 1.23E+569.

How can I either prevent the original text from being converted to begin with or how can I correct it after the fact?

Best regards,

I am experiencing an issue with number format in excel 2007 small business version. Whenever I store any number with decimal point it consider it as a text, for example I enter 2.50 it stays left aligned and when we enter other numbers and try to sum the numbers it does not give correct result as it does not consider the numbers with decimal point as number but instead considers them as text. If I enter a number without decimal point it works fine.

Moreover even if I change the decimal number format to number it still does not change to number format and it remains left aligned as if it were a text. I have tried to uninstall MS Office and then reinstall it again but still the problem persists. Please advice what could be a possible reason for this issue...

I am attaching a specimen of the file with issue...

Whenever I place a numeric value in a cell, it applies a currency format with the British pound sign.

Given that most of my input is in Australian dollars, I would prefer that the default is $.

How do I change this? My settings in Windows Control Panel are in Australian dollars but Excel insists in inserting the English pound sign, suggesting that my problem rests with a setting I have in Excel.


Hi Everyone,

I'm tryng to convert a text file that is comma separated into a csv. I've done this hundreds of times in the past but one thing really puzzles me and I'd appreciate any guidance on how I can fix this.

In the text file I have some bank details whic show sort code and bank account number. These are separted in teh text file correctly with commas as in teh example below.


When I open the text file using excel and import it. I select the format of Text for all columns and excel displays the data. Now to my problem, in the column where the sort code is contained "AH" (in the example above that is 11-11-11) Some of the cells show these as a date format such as 11/06/1941 while other cells show this information correctly formated as 11-11-11. I can see no logical reason why for example these cells format incorrectly


Those are just a few examples to show the apparent randomness of the issue. The text file itself looks 100% error free.

It's as if Excel ignores the format command on some cells during the import. Can anyone help me with this problem?

I'm using Excel 2007



My apologies in advance if I don't use correct terminology, I'll do my best to relate what I'm seeing. I have an Excel file that is the output of a macro on another Excel file. If If I'm using Excel with other files, and I open this output file as well, the background colors on my originally open files will change.

If, after this change, I close the changed files and the output file, and reopen the changed files in that instance of Excel, the colors are still changed.

If I fully close that instance of Excel, and open the original files in a new instance of Excel, the colors have then reverted to their original colors.

Checking the cell format option before and after opening the file, it looks like three of the cell shading colors change. I'm using one of these colors, so it then changes the color on the sheet.

In the macro, I use a lot of variations of
If ActiveCell.Value = "B536P " Then
Selection.Interior.ColorIndex = 54
Selection.Font.ColorIndex = 2
Selection.Font.Bold = True

I'm using Excel 2003, SP3.

Any ideas, or more information needed?


I have a file in which on one of the tabs an equal sign is placed in front if numbers are entered. For instance, if I type "1/1/07" in the cell, instead of a date being entered, excel is putting an equal sign out front so it actually divides 1/1/07 giving a real small number.

There are other worksheets in this workbook, but they don't have this issue. I can't figure out what is going on. Any help would be much appreciated. Thanks.

I can copy and paste my debit card purchaes from my bank - online.

The numbers are in a column and appear as $14.34 (ex.)- with a dollar sign
in front of them.

I can't sum these numbers. I select them all and convert them to a number
format and they still won't sum.

I f2 the cell and remove the dollar sign and they still won't sum (sum = 0)

Any ideas?

Hello everyone!

I have a problem, and while I do have backup files (a week old), I cannot think of any reasonable explanation for what is happening.

Last night a co-worker was working on a Shared File, was doing some text inputs (adding dates & notes) and some format changes (highlighting certain cells). They saved and closed out the file (in .xlsx format as it has always been) using Excel version (12.0.6504.5001) SP1 MSO (12.0.6320.5000).

This morning, when the tracker was being opened, an error displayed as follows:

"Excel found unreadable content in 'filename.xlsx'. Do you want to recover teh contents of this workbook? If you trust the source of this workbook, click Yes. (Yes) (No)"

I hit Ctrl-Shift-i to get the code for the error (101648)

Clicking no the first time and making a copy of the file, then click Yes. Yet another error is displayed as follows:

"Excel cannot open the file 'filename.xlsx' because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file. (OK)"

I hit Ctrl-Shift-i to get the code for that error (101590)

I then tried to open a new workbook and link it to certain cells, but it morphs my formula and returns a #REF error

The original formula I type in is:


='[S:\File Location\filename.xlsx]Sheet1'!A1

The formula that I see after I hit enter is:


='[S:\File Location\[filename.xlsx]Sheet1]filename.xlsx]'!A1

Which is just odd in and of itself, so then I started browsing google to see if anyone else had encountered such an issue, and while I could find responses on the errors alone, I couldn't find anything that matched what was happening to me.

I also tried to rename the file to .xls and .xlsb and tried to open the file. As well as using Excel 2003 with the converter to open the file.

So far everything I have tried has failed to work.

Has anyone seen anything like this? Have any thoughts on solutions?

Your help is greatly appreciated!

Thank You,


I have a very long list laid out in the following manner,

Item 1 ~~ Item 2 ~~ Difference
3.5 ~~~~ 3.5 ~~~~ 0
4.2 ~~~~ 3.7 ~~~~ 0.5
-5 ~~~~ -5 ~~~~~ 0

I need to see if the difference is more than 1% of the original value in list 1.
I can work this out for the positive numbers, but when I copy the formula through cells it doesnt work on negative numbers.


Any ideas on how I can ignore the sign of the numbers in order to ensure I get correct results?

Thanks in advance.