Snir Hoffman Tech Blog
Showing posts with label excel. Show all posts
Showing posts with label excel. Show all posts

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
Older Posts Home
Subscribe to: Posts (Atom)

Blog Archive

  • ▼  2026 (1)
    • ▼  March (1)
      • Long time... How to fix subtitles files for hebrew...
  • ►  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)
    • ►  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.