LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 50
Default number not recognised

i have received a spreadsheet in which some numbers appear to be entered as
text. i have tried the =value(text) function but am not able to convert them
back to numbers. please help.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
dates not recognised DL Excel Discussion (Misc queries) 1 May 27th 10 11:33 PM
UserInterfaceOnly not being recognised jillc Excel Programming 3 December 13th 07 06:14 PM
cell value not recognised svb Excel Programming 1 November 5th 06 08:11 PM
Excel VBA not recognised dhiraj Excel Programming 1 June 2nd 04 06:52 PM
Name not recognised Jerome_t Excel Programming 5 April 23rd 04 06:10 PM


All times are GMT +1. The time now is 03:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"