| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
if 01222 in A1
B1 ="*"&value(A1) but * is an operator, so expect to have unexpected trouble with this down the road. On Mon, 7 Mar 2005 21:17:58 +0000, jblack35 wrote: How do you add an asterisk to the begining of a excel cell? or replace the zeros with a asterisk? For example, data come in the cell as 01222 but I want it like this:*12222 Thanks, Jim |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel to Excel, Cut & Paste, 1 cell, text, multiplies file size f. | Excel Discussion (Misc queries) | |||
| I have typed in an excel cell and cannot advance to next cell by . | Excel Discussion (Misc queries) | |||
| How do I search for an asterisk in an Excel file--it thinks the a. | Excel Discussion (Misc queries) | |||
| Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
| Writing many lines on a same Excel 2000 cell | Excel Discussion (Misc queries) | |||
Threaded Mode
