| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenate numbers
I want to be able to insert a phrase such as Month 3 where the month number
is entered in a different cell (say B4). I have therefore entered formula - concatenate("month ",B4) and it returns a #value! error. Both cells have general format. When I do this on a brand new spreadsheet i don't have a problem in that it displays as Month 3 so there must be a problem on the spreadsheet i am using which is causing this. Does anybody have any clues? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I concatenate custom formatted numbers | Excel Worksheet Functions | |||
| VBA to concatenate Text and/or Numbers and/or dates etc | Excel Discussion (Misc queries) | |||
| Format numbers / Concatenate | Excel Discussion (Misc queries) | |||
| concatenate with numbers | Excel Discussion (Misc queries) | |||
| Concatenate text and numbers? | Excel Worksheet Functions | |||
Threaded Mode
