Snir Hoffman Tech Blog

04 November, 2010

convert excel tesxt to numbers

Hi,

Just wanted to let you know that I found a way to convert numbers that apear as text back to numbers.
If you have a formula that retrieve a number with a text function, when I try to do a vlookup on this it would not work.
Just multiply it by 1 and you will be OK.
Posted by Snir Hoffman at 1:10 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: excel
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Blog Archive

  • ►  2016 (2)
    • ►  September (1)
    • ►  April (1)
  • ►  2015 (2)
    • ►  July (1)
    • ►  January (1)
  • ►  2014 (11)
    • ►  December (1)
    • ►  October (1)
    • ►  September (4)
    • ►  August (1)
    • ►  July (1)
    • ►  April (1)
    • ►  February (1)
    • ►  January (1)
  • ►  2013 (2)
    • ►  February (1)
    • ►  January (1)
  • ►  2012 (2)
    • ►  August (1)
    • ►  May (1)
  • ▼  2010 (38)
    • ▼  November (1)
      • convert excel tesxt to numbers
    • ►  September (8)
    • ►  August (5)
    • ►  July (6)
    • ►  June (3)
    • ►  May (7)
    • ►  April (1)
    • ►  March (2)
    • ►  February (3)
    • ►  January (2)
  • ►  2009 (12)
    • ►  December (1)
    • ►  September (1)
    • ►  August (2)
    • ►  July (1)
    • ►  May (3)
    • ►  April (4)

About Me

My photo
Snir Hoffman
System Expert, Love movies and the internet...
View my complete profile
Simple theme. Powered by Blogger.