Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cannot change the format to $ sign because there is space
I have to chage the format of Price 123.42 to $123.42 but in the beggining of
123.42 there is a space and I tried to go to format and click into the $ but that wont happen. I have 1000lines where I have to change to 123.42 to $123.42 but because of the space I have to delete the space then go to format and $ sign. I can't copy and do paste special it won't let me. Column A Column B 123.41 $123.41 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cannot change the format to $ sign because there is space
What happens if you format as Currency with $? Or is that what you mean by
"format and $ sign"? Blanks in front of numbers should be ignored "Cynthia Amrit" <Cynthia wrote in message ... I have to chage the format of Price 123.42 to $123.42 but in the beggining of 123.42 there is a space and I tried to go to format and click into the $ but that wont happen. I have 1000lines where I have to change to 123.42 to $123.42 but because of the space I have to delete the space then go to format and $ sign. I can't copy and do paste special it won't let me. Column A Column B 123.41 $123.41 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cannot change the format to $ sign because there is space
I mean when I right click and format I can't get 123.42 to $123.42. Excel
won't allow me. How can I do this instead of manually typing $? "toppers" wrote: What happens if you format as Currency with $? Or is that what you mean by "format and $ sign"? Blanks in front of numbers should be ignored "Cynthia Amrit" <Cynthia wrote in message ... I have to chage the format of Price 123.42 to $123.42 but in the beggining of 123.42 there is a space and I tried to go to format and click into the $ but that wont happen. I have 1000lines where I have to change to 123.42 to $123.42 but because of the space I have to delete the space then go to format and $ sign. I can't copy and do paste special it won't let me. Column A Column B 123.41 $123.41 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cannot change the format to $ sign because there is space
How is cell currently formatted? And what does "Excel not allow me mean"?
Typing 123.45 into a cell, right click, format as Currency with $ symbol should work. "Cooliegirl2323" wrote in message ... I mean when I right click and format I can't get 123.42 to $123.42. Excel won't allow me. How can I do this instead of manually typing $? "toppers" wrote: What happens if you format as Currency with $? Or is that what you mean by "format and $ sign"? Blanks in front of numbers should be ignored "Cynthia Amrit" <Cynthia wrote in message ... I have to chage the format of Price 123.42 to $123.42 but in the beggining of 123.42 there is a space and I tried to go to format and click into the $ but that wont happen. I have 1000lines where I have to change to 123.42 to $123.42 but because of the space I have to delete the space then go to format and $ sign. I can't copy and do paste special it won't let me. Column A Column B 123.41 $123.41 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cannot change the format to $ sign because there is space
I mean when I right click and format I can't get 123.42 to $123.42. Excel
won't allow me. How can I do this instead of manually typing $? I presume since the cell has a retained blank space, it is text and not a number. While this is not an ideal solution by any means (it keeps the leading blank space and doesn't round any values to 2 decimal places), but it does display whatever text is in the cell with a leading $ sign... use $@ in a Custom Format. Rick |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cannot change the format to $ sign because there is space
1. Insert a helper column in your data.
2. Use the formula =--trim(a1) to convert your text (' 123.42') to a number (123.42) 3. Use copy and Paste SpecialValues to store the values rather than the formula 4. Format the column as currency 5. Delete the original column -- Regards, Fred "Cynthia Amrit" <Cynthia wrote in message ... I have to chage the format of Price 123.42 to $123.42 but in the beggining of 123.42 there is a space and I tried to go to format and click into the $ but that wont happen. I have 1000lines where I have to change to 123.42 to $123.42 but because of the space I have to delete the space then go to format and $ sign. I can't copy and do paste special it won't let me. Column A Column B 123.41 $123.41 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can i change dollar sign to rupee sign in sales invoice | Excel Discussion (Misc queries) | |||
Change the space used for my x-axis labels | Charts and Charting in Excel | |||
can I change the $ sign to a £ sign in an MS template? | Excel Worksheet Functions | |||
How do you change the sign (e.g. +3 to -3 OR -3 to +3) | Excel Discussion (Misc queries) | |||
HELP - I need to change space delimited to comma? | Excel Discussion (Misc queries) |