Re: NEED HELP..CONVERT NUMBERS BACK TO TEXT

Can you post the text that you start with, and tell us how you convert
it to a number? This will help with a solution. If you have an entry
such as '0012345 (note the leading apostrophe in the entry) then Excel
will treat that as text. You may be able to bypass the text to numeric
conversion with a formula such as =VALUE(A1) where A1 contains the
'0012345. That way you could use the converted value without losing
the text entry.

Also, what do you mean by "I'm aware the last number will change to 0"?

.

Relevant Pages

  • Re: Compile problem
    ... If that's been set wrong by the conversion, ... the "Entry Point" as you said, ... compile process is OK. ... unresolved external symbol wWinMain referenced ...
    (microsoft.public.windowsce.embedded)
  • [paint] Painting Challenge 2006
    ... RGMW 1st Annual Painting Challenge ... Only ONE entry per person per Category. ... No "conversion" work of any type is allowed: NO bitz, NO cutting, NO bending, NO scupting, NO banners. ... Post a link to your entry in RGMW. ...
    (rec.games.miniatures.warhammer)
  • Re: Problem with Return Value from a Function
    ... for the appropriate ENTRY point, so it needs to know which ENTRY ... Compilers I know of generate an epilog routine for each ... For each entry there can be one and only one conversion. ... a unique conversion. ...
    (comp.lang.pl1)
  • Re: Painting Challenge 2006
    ... Only ONE entry per person per Category. ... People may compete in as ... ANY model and/or conversion that follows the Inquisitor theme. ... but models may only be mounted on standard-sized gaming bases ...
    (rec.games.miniatures.warhammer)
  • Re: Compile problem
    ... it really means that the "Entry Point" is there ... DLL/LIB file contains the wWinMain which the Linker needs to know. ... If that's been set wrong by the conversion, ... compile process is OK. ...
    (microsoft.public.windowsce.embedded)