Excel Numbers and text

  • Thread starter Thread starter Karlos
  • Start date Start date
K

Karlos

is there a way i can combine text and a value from another
cell but have the result identified as a number

for example i tried:

="Cell Value is"&" "&A1

this returns for example "Cell Value is 10"

however that cell is now identified as a text cell and i
cant use it in calculations.

how can i do the same thing but have the result in a cell
which is identified as a number cell

Thxs In Advance
 
Hi Karlos!

You could use custom format:

"Cell value is "#,##0

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top