If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Formatting to Currency does not get applied
I have a column of numbers formatted without dollar signs
& decimal points: 1234 5678 9100 I want to apply Currency formatting with decimal points. I select the cells, apply the formatting but it doesn't change how the cells are displayed. There's no conditional formatting on the cells - I can't figure out why it isn't allowing me to change the cell format. Any ideas? |
#2
|
|||
|
|||
Formatting to Currency does not get applied
Hi
When you select Currency from the Format Cells list, does it show a symbol on the right hand side of the dialog box? -- Andy. wrote in message ... I have a column of numbers formatted without dollar signs & decimal points: 1234 5678 9100 I want to apply Currency formatting with decimal points. I select the cells, apply the formatting but it doesn't change how the cells are displayed. There's no conditional formatting on the cells - I can't figure out why it isn't allowing me to change the cell format. Any ideas? |
#3
|
|||
|
|||
Formatting to Currency does not get applied
Yes, it shows the $ in the "Symbol" field but in the
sample at the top of the dialog box it doesn't have the $ applied either. -----Original Message----- Hi When you select Currency from the Format Cells list, does it show a symbol on the right hand side of the dialog box? -- Andy. wrote in message ... I have a column of numbers formatted without dollar signs & decimal points: 1234 5678 9100 I want to apply Currency formatting with decimal points. I select the cells, apply the formatting but it doesn't change how the cells are displayed. There's no conditional formatting on the cells - I can't figure out why it isn't allowing me to change the cell format. Any ideas? . |
#4
|
|||
|
|||
Formatting to Currency does not get applied
My guess is that the "numbers" are actually text.
Copy an empty cell. Select your range of numbers and Paste SpecialAddOKEsc. Format as Currency. Gord Dibben Excel MVP On Tue, 15 Jun 2004 07:11:56 -0700, wrote: Yes, it shows the $ in the "Symbol" field but in the sample at the top of the dialog box it doesn't have the $ applied either. -----Original Message----- Hi When you select Currency from the Format Cells list, does it show a symbol on the right hand side of the dialog box? -- Andy. wrote in message .. . I have a column of numbers formatted without dollar signs & decimal points: 1234 5678 9100 I want to apply Currency formatting with decimal points. I select the cells, apply the formatting but it doesn't change how the cells are displayed. There's no conditional formatting on the cells - I can't figure out why it isn't allowing me to change the cell format. Any ideas? . |
#5
|
|||
|
|||
Formatting to Currency does not get applied
Ok - I've discovered the problem. There is a blank space
in each of the cells after the amount: 1234 _ If I click on the individual cells and backspace out the blank character, it will change the formatting to currency. Isn't there a way I can remove these blank spaces automatically? I've tried =TRIM and it doesn't work. Is there something I can put in Replace to make it remove all blank characters after the cell value? -----Original Message----- My guess is that the "numbers" are actually text. Copy an empty cell. Select your range of numbers and Paste SpecialAddOKEsc. Format as Currency. Gord Dibben Excel MVP On Tue, 15 Jun 2004 07:11:56 -0700, wrote: Yes, it shows the $ in the "Symbol" field but in the sample at the top of the dialog box it doesn't have the $ applied either. -----Original Message----- Hi When you select Currency from the Format Cells list, does it show a symbol on the right hand side of the dialog box? -- Andy. wrote in message . .. I have a column of numbers formatted without dollar signs & decimal points: 1234 5678 9100 I want to apply Currency formatting with decimal points. I select the cells, apply the formatting but it doesn't change how the cells are displayed. There's no conditional formatting on the cells - I can't figure out why it isn't allowing me to change the cell format. Any ideas? . . |
#6
|
|||
|
|||
Formatting to Currency does not get applied
In that case, there could be HTML non-breaking space characters(160)in the
data. You could try the CLEAN Function. Or to do with a Macro, see David MCritchie's TRIMALL macro for further cleaning. http://www.mvps.org/dmcritchie/excel/join.htm#trimall Gord Dibben Excel MVP On Tue, 15 Jun 2004 08:25:58 -0700, wrote: Ok - I've discovered the problem. There is a blank space in each of the cells after the amount: 1234 _ If I click on the individual cells and backspace out the blank character, it will change the formatting to currency. Isn't there a way I can remove these blank spaces automatically? I've tried =TRIM and it doesn't work. Is there something I can put in Replace to make it remove all blank characters after the cell value? -----Original Message----- My guess is that the "numbers" are actually text. Copy an empty cell. Select your range of numbers and Paste SpecialAddOKEsc. Format as Currency. Gord Dibben Excel MVP On Tue, 15 Jun 2004 07:11:56 -0700, wrote: Yes, it shows the $ in the "Symbol" field but in the sample at the top of the dialog box it doesn't have the $ applied either. -----Original Message----- Hi When you select Currency from the Format Cells list, does it show a symbol on the right hand side of the dialog box? -- Andy. wrote in message .. . I have a column of numbers formatted without dollar signs & decimal points: 1234 5678 9100 I want to apply Currency formatting with decimal points. I select the cells, apply the formatting but it doesn't change how the cells are displayed. There's no conditional formatting on the cells - I can't figure out why it isn't allowing me to change the cell format. Any ideas? . . |
Thread Tools | |
Display Modes | |
|
|