Close Window   
Free Ebook
Get Your Free Excel
ebook!
Our Top 15 Excel Tutorials
Instant Access!
E-mail:
Subscribe for Free Excel tips & more!
E-mail:
Advertisements



Excel 2010 Keeps Changing Format From Number To Currency

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

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

View Answers     

Similar Excel Tutorials

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

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 $11.000.0.00 or something.
How can I solve this?

Thanks


I know it's been asked a hundred times before, so one more time shouldn't matter.

I want negative numbers in my check register to be displayed in red, maybe bold red. I'm not using a number format but rather an accounting format, so changing the "number" format in Format - Cells - Number doesn't work.

Using the Currency Format will ensure that your numbers will not align evenly down the column, so that's out. Number Format doesn't have a "$" sign, so I don't want to use that either. Accounting is the best, as numbers are even all the way down the sheet and it has the $ sign. Now if I can just get $ (100.00) to show in red, I'd be in business. Red with a minus sign instead of Parenthesis would be even better.


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?

Thanks!
Amy

Amy



Hi,

I need to add a leading zero before month in a text file, but the spacing should same as before after adding the zero also.

I tries using to open with excel and changed the format but after i did the test to columns the spacing of the old format is changed.

Ex:

BUARDC 04294008295 010321 6000 7/17/2010 0000354652 000224

This is the sample data, in this i need to add zero before that "7". but the format should be same like the spacing between the letters and all the numbers also.

Can anyone help me on this i can solve this issue.

Thanks in advance

Vinoth


I'm looking for a way of converting currency and I can't seem to find anything on the board (at least not that I understand how to implement...)

what I have:
Several times a week I get workbooks (all in different layouts) which contain both text and pricing.

What I need:
I need to be able to convert all cells which are formated as a specific currency (GBP, USD and EUR) into one of the orthr currencies.

What I think could be the solution;
A macro or something that performs like this (one fore ach currency) "IF A1:ZZ9999 is formated as currency (GBP) THEN add function =FOREX!C2* in same cell"

The reason fro the add fuction is that I need to be able to see the original numbers and update the exchage rate on a going basis.

Is this possible???

Thanks in advance


Hi all the excel experts,

I have a file contains thousands of rows of purchasing order. the purchasing value is in different local currency,the data(number) format is "Accounting" .

Is there a way to separate the currency sign and the number into different column?

I need to the currency sign to be able to convert data to desired currency. But Excel read the data as number. so I was doing it row by row. Such a pain and not efficient.

Anyone can help on that?

Thanks in advance/


Excel 2007: I'm trying to print negative numbers in parentheses in my worksheet. When I go to the numbers dialogue box and click "numbers" or "currency", the only options that are shown are to print negative numbers with a minus sign, or print in red. When I format my cell to "numbers", "currency" or "accounting" and enter a negative number, it appears with a minus sign in front of the number.

I also have Excel 2007 on my laptop and am not experiencing any problems. Negative numbers appear in parentheses in the number, currency and accounting formats.

Have I inadvertently adjusted a setting somewhere? Thanks for any help anyone can provide.

Ray


I use a file to download into excel, however in the downloaded file negative numbers come over with the negative sign at the end of the number and in how can I easily convert them to negative currency numbers in excel. I have been putting the number sign at the beginning and then deleting the one at the end, but I am sure there is an easier way.

Thank you in advance


Hi,

I don't know what is wrong with my excel setting... I'm not able to see some of the numbers (in currency/accounting) in excel file, it shows as many "#" sign, and it's not due to the column width. The same file can be seen in other computer.

The format setting is the same in all the cells but only certain rows/cells' numbers appear like "normal".

Please help.

Thanks!
Alice


I have a large excel sheet containing many numbers and formulas. The user can choose from a drop-down list the currency to use (USD, GBP, EUR, JPY). Each time the currency has been changed all the cells will be recalculated using the new currency and also the cell currency format is changed.

What would be the most efficient way to solve this problem with VBA or excel? Thanks for your help.


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

Shaunym


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,



I have just purchased a netbook an installed Excel 2003 on it. I have copied all my Excel data files from my desktop where all negative numbers are in parenthesis. The files in the netbook, however, are showing a negative sign. I have customised the Regional Settings so that negative numbers and currency are in parenthesis, however, these options do not appear when I choose Format, Cells Numbers or Currency - only the negative sign option is shown. How do I get a general change so that all negative numbers in all Excel worksheets can be in parenthesis.


I did not intentionally change anything. Starting today, when I open a new file and go to format the numbers, I no longer have the option under either "number" or "accounting" to select that negative numbers be displayed with parenthesis (). When I open an old file that I know I formatted this way using "accounting", those negative numbers still show with "()" instead of "-" but when I check Format - Numbers it shows me that the cell is formatted as "Custom". I know for a fact that I formatted that cell with "Accounting" and it had "()". Does anyone know why my "Accounting" format for negative numbers mysteriously changed from "()" to "-"? I'd like to change it back and I don't want to have to keep creating "Custom" formats just to get "()" for my negative numbers. I have not changed versions of Excel and I'm working on the same PC as always. The only thing I can think of is I opened an Excel file that was sent to me internationally and formatted "-" instead of "()" but I can't understand why that would change my default "accounting" format. Any help?


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


All,

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!

Cheers.


I have a new problem that has cropped up with the autofill feature. When trying to create new file numbers, i.e. 5000-5999, I enter 5001, 5002, 5003, in three consecutive cells. Then I try to autofill the remained by selecting the three cells and pulling down from the + indicator. However, all I am getting is the same three (or two, or four, if I try that many) file numbers, instead of the new consecutive numbers. I've tried changing the column format to general, number, and text, and disabling a macro that runs on this page, all to no avail. This has not happened to me before, as the existing file numbers up to 5000 were created in this very fashion!

I'm a bit stumped - any help/input from some pro's or somebody who may have encountered this type of problem before is greatly appreciated.

TIA
Bob


Lately I have been having this weird formatting glitch show up on my excel sheets. For some reason all of my numbers that were previously formated as numbers are now being formatted differently. It started with dates, I would open my sheet and all of the numbers and blank cells were formatted as dates. Now they are formatted as currency (Euros). This has happened in several of my files and I have no idea why. Any thoughts? Thanks.


I have been working in a worksheet with 10 tabs, and suddenly all of my numbers turned to long date format. I manually changed them all back to what they were. General, Currency, %, etc. but the default seems to be stuck in the long date format. When I create a new tab it is automatically all long dates. Very strange.
Oh, and the other weird thing is when I send it to other people, some people see the correct formats and when other's open it the numbers all go back to the long date format. VERY Frustrating.
Would love to get some advice.


Hi all,

Using Excel 2010.

I would like a customer number format with a leading "+" for positive number and a leading "-" for negative numbers.

My string works for positive numbers + 200.00 but not negative numbers.
The negatives display as (200.00). I would prefer - 200.00.
Current display string:
"+"_(* #,##0.00_);_(* (#,##0.00);"-"_(* "-"??_);_(@_)

I tried copying the format for positive numbers into the display for negative values and changed the sign, but that still displayed as (200.00)

I tried some variations on the format string such as
"+"_(* #,##0.00_);_(* (#,##0.00);"-"_*#,##0.00_;_(@_)

But I received back an error message:
Microsoft Excel cannot use the number format you typed

Any thoughts on how I can get the display I would like?


How do I disable Excel from automatically changing my data when I first open the excel sheet?

I know how to stop it once I have opened the sheet and before entering in information, I can format the column as text and it will not think my numbers are dates or something, but what I need to know is.............

Can I set Excel not auto correct any data in the sheet when I open it?

Here is an example of typical entries that are changed frequently:

Long Numbers
ORIGINAL ENTRY: 625617000001
EXCEL SHOWS: 6.25617E+11 (Even when the column width is expanded)

Other Issues
ORIGINAL ENTRY: AUG11
EXCEL SHOWS: 11-AUG

ORIGINAL ENTRY: 11-12-04
EXCEL SHOWS: 11/12/2004

These are actually part numbers, not dates, or scientific numbers. I do not want Excel to change these entries, especially when I have thousands of variations of the above examples. Trying to correct all of them would be a nightmare.

(I am using Excel 2003)

Thank you for your help!



How do I disable Excel from automatically changing my data when I first open the excel sheet?

I know how to stop it once I have opened the sheet and before entering in information, I can format the column as text and it will not think my numbers are dates or something, but what I need to know is.............

Can I set Excel not auto correct any data in the sheet when I open it?

Here is an example of typical entries that are changed frequently:

Long Numbers
ORIGINAL ENTRY: 625617000001
EXCEL SHOWS: 6.25617E+11 (Even when the column width is expanded)

Other Issues
ORIGINAL ENTRY: AUG11
EXCEL SHOWS: 11-AUG

ORIGINAL ENTRY: 11-12-04
EXCEL SHOWS: 11/12/2004

These are actually part numbers, not dates, or scientific numbers. I do not want Excel to change these entries, especially when I have thousands of variations of the above examples. Trying to correct all of them would be a nightmare.

(I am using Excel 2003)

Thank you for your help!




In the past, I have downloaded a .csv file, comma separated, which listed the contents in a column style/format.

The most recent file I downloaded [.csv file, comma separated] lists the same information in a linear format with vertical lines separating what used to be in individual columns.

I have not changed my Excel settings.

Is there anything I am able to do to convert this file back to the original format? Or is this an issue with the file format at the originating point?

(the attached is a small piece of the actual & very large file; both original and current)

Thank you for any help.

Hi All,

Hoping someone may assist with an issue I've recently encountered.

I have an excel file (2000) version - there are 12 worksheets all containing a number of bar/line graphs. Whenever I add a small image in each of the sheets and try to re-open the file excel encounters an error and immediately shuts down.

When I open the file in Excel 2007 (without the images) it actually removes every graph across all of the work sheets ("file error: data may have been lost"). I myself use 2007 but save the file in .xls format as the people I send it to use 2000.

I've been able to successfully access/edit the file in both 2000 & 2007 excel in the past - this only started to happen since making a few changes to the graphs.

At this stage I'm thinking it may simply be a compatability issue, but if anyone has encountered this before and knows why this is happening that would be much appreciated...

Thanks,


I am trying to export a file into excel, as a csv file. The file contains long numbers. Each time I export, the numbers appear like this: 9.1810E+21, when the actual number might be 91011245369812365478. I read elsewhere to do Format > Cells > Text to get rid of the issue, but when I do that, the last 6-8 numbers are replaced by zero's.

Someone said to increase the amount of characters per field and another said to disallow rounding of numbers, but I dont know how to do this.

Any opinions?