Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Insert a keyboard Character e.g (/)in multiple cells of a workshee
I want to change my data, in excel, from the form, e.g (100) to (100/100)
for another software to recognize the data. The data is huge and wish I could do it automatically . I have tried the 'Concatenate' formula but it returns the product of the formula instead of the form I want it. Any help please? =concatenate A1,/A1 meant to change (100) to (100/100) returns (1) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Insert a keyboard Character e.g (/)in multiple cells of a workshee
You need to show that the slash is text not a math operator
either =CONCATENATE(A1, "/",A1) or, more simply, =A1 & "/" & A1 best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Mike" wrote in message ... I want to change my data, in excel, from the form, e.g (100) to (100/100) for another software to recognize the data. The data is huge and wish I could do it automatically . I have tried the 'Concatenate' formula but it returns the product of the formula instead of the form I want it. Any help please? =concatenate A1,/A1 meant to change (100) to (100/100) returns (1) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Insert a keyboard Character e.g (/)in multiple cells of a workshee
=concatenate A1,/A1 is not a valid syntax for a formula, so I very much
doubt that you have used that and returned (1). Perhaps you'd like to tell us what you *have* used? [Copy and paste from the formula bar; don't try to retype into the newsgroup.] Valid syntax could be either =CONCATENATE(A1,"/",A1) or =A1&"/"&A1 but if you have parentheses around the number then you need to be careful as to whether that is text or a negative number formatting, and then you'd need to decide what answer you wanted in which situations. -- David Biddulph "Mike" wrote in message ... I want to change my data, in excel, from the form, e.g (100) to (100/100) for another software to recognize the data. The data is huge and wish I could do it automatically . I have tried the 'Concatenate' formula but it returns the product of the formula instead of the form I want it. Any help please? =concatenate A1,/A1 meant to change (100) to (100/100) returns (1) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
keyboard shortcut for " insert copied cells" ? | Excel Discussion (Misc queries) | |||
Add the same character(s) to multiple cells in a column (or row) . | Excel Discussion (Misc queries) | |||
how do i calculate the average of 30+ cells over multiple workshee | Excel Worksheet Functions | |||
How do I get Excel 2004 Mac to insert cells vis keyboard shortcuts | Excel Discussion (Misc queries) | |||
How do I insert a comment in unlocked cell of a protected workshee | Excel Worksheet Functions |