Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Text
They are defined as text - how do i convert the mto numbers
I used Format - cells - number - but it did not work On Mon, 19 Jan 2004 03:26:23 -0800, Bas van Heek wrote: Are you sur the cells containing numbers are defined as numbers (format cells-Numbers)? If they are defined as text you cannot calculate them.. Regards Bas |
#2
|
|||
|
|||
"yahoo" wrote
They are defined as text - how do i convert the mto numbers I used Format - cells - number - but it did not work Bas van Heek wrote: Are you sur the cells containing numbers are defined as numbers (format cells-Numbers)? If they are defined as text you cannot calculate them.. Formatting does not change the underlying values Try this: Right-click on an *empty* cell Copy Right-click on the range/col of "text" numbers Choose Paste special Add OK -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
How do I rotate a text box | Charts and Charting in Excel | |||
Putting text in a column based on variable text from another colum | Excel Discussion (Misc queries) | |||
how to hyperlink text to a cell | New Users to Excel | |||
Macro or Function to make text size to suite text Length? | Excel Discussion (Misc queries) |