| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to format alphanumeric cells as numbers
if i have a series of cells with numbers and letters (i.e. 43A or 33B, etc)
how can i get excel to see them only as numbers so when i graph them they show up as 43 or 33 but also include the letter in the data label. Right now I have to delete the text from the cells before i graph them, then manually insert them in the data label after i create the graph. I'm hoping there's away to graph it with the letter in tact. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why will my cells not format? | New Users to Excel | |||
| Format Excel cells | Excel Discussion (Misc queries) | |||
| Change CSV-load cell format from GENERAL to TEXT for numbers? | Excel Discussion (Misc queries) | |||
| How do I only calculate cells which have a filled color format? | Excel Discussion (Misc queries) | |||
| Microsoft Excell does not format the data numbers right justified. | Excel Discussion (Misc queries) | |||
Threaded Mode
